tFileOutputDelimited not returning results

[Garrett]

The following job includes these components

tDBInput -> tFileOutputDelimited

MS SQL to CSV file

the job runs successfully indicating 295 rows but the csv file comes up blank.

[Anonymous]

Hi,

    Could you please delete the existing file and try to run it again? Also please check the schema of the database output.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Garrett]

Hello,

Please see below screenshot. This is my setting for the tFileOutputdelimited component. Which settings in this window were you suggesting to change?

[Anonymous]

Hi,

    Please refer below.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Garrett]

can you please point out the difference between your screenshot and mine? the advanced settings seem to be the same. Which setting do I need to change specifically?:

[akumar2301]

Hello

Did you defined schema in tfileoutput component?

[Garrett]

I didn't make any changes there. this is how my schema looks on tfileoutput:

[akumar2301]

Aah you need to define schema at input and output.

Schema contains col names , data type etc...

[Garrett]

thanks i was able to generate the output in the csv file. now, in the csv file all of the columns of data are in one cell and the column headers are also in the first cell separated by ;. How can I make sure  that the data is in each of the columns?

[Anonymous · Accepted solution]

@Garrett 

The field separator value defines the data separator attribute between columns. You can change it to comma instead of semicolon if your target system is looking for "," symbol.

Please also refer the below sample scenario which will give you better idea.

https://help.talend.com/reader/wDRBNUuxk629sNcI0dNYaA/F3_A62DeXoPWn7ZjeK7BOw

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂