topic Re: tFileOutputDelimited seperated via columns in Talend Studio

tFileOutputDelimited seperated via columns

noobTalendDev — Fri, 15 Nov 2024 23:02:58 GMT

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?

Re: tFileOutputDelimited seperated via columns

noobTalendDev — Tue, 05 Apr 2022 02:35:57 GMT

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

Re: tFileOutputDelimited seperated via columns

gjeremy1617088143 — Tue, 05 Apr 2022 07:29:12 GMT

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

Re: tFileOutputDelimited seperated via columns

noobTalendDev — Tue, 05 Apr 2022 17:11:04 GMT

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.

Re: tFileOutputDelimited seperated via columns

Anonymous — Wed, 06 Apr 2022 02:45:39 GMT

Hello,

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

Best regards

Sabrina