Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
noobTalendDev
Contributor
Contributor
‎2022-04-04 09:57 PM

tFileOutputDelimited seperated via columns

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?

Labels (3)
Labels
168 Views
0 Likes
4 Replies
noobTalendDev
Contributor
Contributor
‎2022-04-04 10:35 PM
Author

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

168 Views
0 Likes
gjeremy1617088143
Master
Master
‎2022-04-05 03:29 AM

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

168 Views
0 Likes
noobTalendDev
Contributor
Contributor
‎2022-04-05 01:11 PM
Author

In response to gjeremy1617088143

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.

168 Views
0 Likes
Anonymous
Not applicable
‎2022-04-05 10:45 PM

In response to noobTalendDev

Hello,

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

Best regards

Sabrina

168 Views
0 Likes