Need to create duplicate header on file from db input.

sashish — Fri, 15 Nov 2024 23:02:33 GMT

I need to create duplicate header row in file.

I am getting data from tpostgresinput but not able create duplicte haeders.Attached is my simple flow

FLOW : table input ----------------> FileOut

table input -

column A,Column B

"test","new"

File out

column A,Column B

"test","new"

if there is no data in table input then atleast duplicate header should come.

Thanks

Ashish

Re: Need to create duplicate header on file from db input.

Anonymous — Thu, 07 Apr 2022 13:54:54 GMT

I am not entirely sure what you are asking here. Do you just want a duplicate header at the very top like this...

column A,Column B <---Header 1

column A,Column B <---Header 2

"test","new" <--- Data row 1

"test2","new2" <--- Data row 2

....or do you want a new header before each row. Like this.....

column A,Column B <---Header 1

column A,Column B <---Header 2

"test","new" <--- Data row 1

column A,Column B <---Header 3

"test2","new2" <--- Data row 2

column A,Column B <---Header 4

"test2","new2" <--- Data row 3

If it is the first, then it would be easier for you to just add the two headers in a separate Subjob and then append to the file with you tDBInput.