.csv file to pivot table

[ainaasyhda (Ainaa Syuhada)]

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?

[Yoichi]

Hi,

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

Regards,

[ainaasyhda (Ainaa Syuhada)]

Thanks! its working!