Sorry for bringing this up, but does anyone have any ideas.
Is there any way to get the header or is it not possible to get it?
Sent: Tuesday, May 09, 2023 at 4:21 PM
From: [email protected]
To: [email protected]
Subject: ETL metadata injection - how to add header to text file
From: [email protected]
To: [email protected]
Subject: ETL metadata injection - how to add header to text file
I'm learning "ETL metadata injection". I succeeded with test transformations but I wonder how to insert header in result text file.
In "ETL metadata injection" hop, in "Text file output" I see; HEADER => Include header row (Y/N).
So I added one more hop, "Add constants", in pipeline where "ETL metadata injection" is with Name "Header", type Boolean and value Y. Then I selected this field in "ETL metadata injection", "Text file output" => HEADER (Add constants: Header).
But header is still not in result file.
What should I do to have it there?
Regards
