How to read data from pivot table in a datatable? Challenge is - As the columns get merged in pivot table, the output odf excel read range activity shows jumbled data instead of showing column-wise.
Please be informed that excel activities fetches the data in same format as it is present in in the pivot table. Hence, we need to change the format how the data is present.
If your table format is like below Compact format
You can the change the format of the Pivot table to a Tabular format in the Design tab.
Then the table will change as below which gives different category values in different columns.
This is represent the data in tabular format so using read range activity we can get the data in datatable format as output.