mito
mito copied to clipboard
Pivot Table Edits: Removing columns from pivot table might delete other columns
- Create a pivot table with two
values
- Insert a new column to the end of the pivot table
- Open the pivot table configuration and delete the one of the values
- Notice that your new column is also gone because it was not able to insert the column at position 4 because the dataframe didn't have 3 columns already.
To fix, if an add column event fails, just add the column using df['New Column Name'] = 0
to add it to the end of the table by default. We would want to handle this inside of the add column step performer.