.csv file to pivot table

Help Studio
, ,
1

Hi,

I have a .csv file and wanted to create a pivot table.
How can i do about this?
What activity should i use?

As for now, to create a pivot table, the source file need to be a .xlsx file.
Do i need to convert my .csv file to .xlsx?

2

Hi,

We can read csv using UseExcelFile, then create pivot table as the following. Can you try this?

image
image1155×1300 39.5 KB

Regards,

3

Thanks! its working!