cwprep

Tools · 22

• add_connection Connect to MySQL/PostgreSQL/SQL Server
• add_file_connection Connect to Excel (.xlsx/.xls) or CSV files
• add_input_sql Custom SQL query input
• add_input_table Direct table connection
• add_input_excel Read from Excel worksheet
• add_input_csv Read from CSV file
• add_input_csv_union Merge multiple CSV files
• add_join left/right/inner/full joins (single or multi-column)
• add_union Merge multiple tables
• add_filter Expression-based filter
• add_value_filter Keep/exclude by values
• add_keep_only Select columns
• add_remove_columns Drop columns
• add_rename Rename columns
• add_calculation Tableau formula fields
• add_quick_calc Quick clean (lowercase/uppercase/trim/remove)
• add_change_type Change column data types
• add_duplicate_column Duplicate (copy) a column
• add_aggregate GROUP BY with SUM/AVG/COUNT
• add_pivot Rows to columns
• add_unpivot Columns to rows
• add_output_server Publish to Tableau Server