Forum Discussion
Pivot from CSV - new columns on refresh
I produce data tables in Julia then view them with Excel Pivot Tables. A nice way to do this is write the data to a .CSV then use "DATA -> From Text/CSV" to load this into an Excel Pivot. An...
Any rows added or altered in the CSV will be added to the Pivot on "Refresh". However, new columns added to the CSV, wont be added to the Pivot on Refresh. Is there a way around this?
See https://answers.microsoft.com/en-us/msoffice/forum/all/power-query-get-transform-missing-column-from-csv/110dbc05-5ca7-4850-906c-1f5437dbce77