How to Convert CSV files to Excel?

Matillion ETL
1

I have an orchestration with two transformations, that send two csv files to a Azure blob storage, then picked up by Azure Blob Storage Unload to push those csv files to sharepoint.

How can I convert those two csv files into excel before going to sharepoint?

I'm new to Matillion and this is my first questions.

Thanks for any help!

 

Transformation > Azure Blob Storage Unload > Azure Queue Storage Message

0694G00000HcihPQAR_0D54G000084Lm3ASAS
0694G00000HcihPQAR_0D54G000084Lm3ASAS831×167 29.7 KB

2

You best option is going to be to use Python. Specifically the pandas module. It's the most versatile python module us data people can use. Take a look at this article: https://datatofish.com/csv-to-excel-python/

 

I hope this helps!