tFileOutputDelimited seperated via columns

[noobTalendDev]

I am currently executing a db query and want to output it to a csv file however i want everything to be seperated via columns so it would be like an xlsx file.

The only reason i am not using tFileOutputXLSX is because i need the csv extension for some other use. How could i get it formatted similar to an xlsx file?

[noobTalendDev]

How would i be able to output a textractdelimitedFields into a csv file?

[gjeremy1617088143]

Hi, tFileOutputDelimited will do the job.

when you open a csv with excel , it will show the result like an excel file

Send me love and kudos

[noobTalendDev]

I am looking to have the csv file by default be the same as an excel sheet. I don't want to have to open it with excel to show the correct format.

[Anonymous]

Hello,

If you only output the xlsx and not the CSV, please have a look at tFileoutputExcel component.

Best regards

Sabrina