topic Re: Generate empty csv file with header in Talend Studio

Generate empty csv file with header

PawelJanus — Fri, 15 Nov 2024 21:09:15 GMT

Hi,

I am unable to create an empty CSV file with a header. If there is no data, it generates an empty file without headers. I need a CSV file that contains only the header without any data. The 'Don't generate empty file' option is unchecked. 'Include header' is checked. If there is no data, the file is empty and with no header.

Re: Generate empty csv file with header

Anonymous — Thu, 11 Jan 2024 08:13:45 GMT

There is no option on tFileOutputDelimited to create a empty file with header. As a workaround, store the data into memory using tHashOutput, write the header to a new file first, then read the data from memory and write them into the new file if there exist data. eg:

tFixedFlowInput--main--tFileOutputDelimited_1

|onsubjobok

tFileInputDeimited--main--tHashOutput_1

|runIf

tHashInput--main--tFileOutputDelimited_2

tFixedFlowInput: generate header value.

tFileOutputDelimited_1: create a new file and writhe the header.

set the condition of runIf as:

((Integer)globalMap.get("tHashOutput_1_NB_LINE"))>0

Regards

Shong

Re: Generate empty csv file with header

konvertilo — Thu, 11 Jan 2024 13:56:55 GMT

If the header is always the same for this file, why don't you create the CSV file with the header only ?

at the end of your job, you could just "cat" the header and the data.

if no data, then the header will be the first and unique row of the file.

if there are some data, you will get the header and the data below.