How to output the data in excel from CSV

[Anonymous]

I'm using tFileOutputDelimited to output the data in CSV to reduce load time, but CSV prints some text errors, to what should i connect it so the data can be converted to xlsx?

[manodwhb]

@Sieg, if you want to read the data from CSV and write it to Excel,you need to design job in below way. if you try to use other component your output file will corrupted.

tFileInputDelimitted>>Row>>Main>>tFileoutputExcel

[Anonymous]

Hi, thanx for the help, that did the trick, is it possible to only output the xlsx and not the CSV? its currently outputing both

[manodwhb]

@Sieg , I did not understand your issue can you share your job design and explain your issue.

[Anonymous]

Hi, i only want to output the "output_xlsx", instead it still outputs the "output_csv" too. Is it possible?

output_csv.csv
output_xlsx.xls

[manodwhb]

@Sieg ,can you share your job design?

[Anonymous]

Hi, yes thank you

Annotation 4.png

[manodwhb · Accepted solution]

@Sieg , you need to generate only xls file then remove tFileoutputdelimited or deactivate it.