Can somebody help me how to output column names to a sequential file
along with data with the delimiter.I am feeding the output of a transformer to a sequential file.
Thanks
Column names in the sequential file output with delimiter
Moderators: chulett, rschirm, roy
One of the options in your sequential file stage is to include the columns names as the first line in the output. I'm not sure if it is a tick-box in PX as it is in Server, but I do know that the option exists in the stage since I've used it before.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Hi rgn_g.
In the sequential file stage, there is an option named: "First Line is Column Names = False". Change it to True.
And in the Format tab of this stage, you can specify which delimiter you want. You can choose "None", "Comma"... or you can even type it is the list... ; for instance...
Hope it helps.
Mathieu
In the sequential file stage, there is an option named: "First Line is Column Names = False". Change it to True.
And in the Format tab of this stage, you can specify which delimiter you want. You can choose "None", "Comma"... or you can even type it is the list... ; for instance...
Hope it helps.
Mathieu
The Brute
ArndW wrote:One of the options in your sequential file stage is to include the columns names as the first line in the output. I'm not sure if it is a tick-box in PX as it is in Server, but I do know that the option exists in the stage since I've used it before.
Will apprecaite if you could tell me exactly which tickbox or setting can make this happen in a PX job to output columns with delimiter along with data and delimiter.Thanks
Didn't Mathieu answer it for you?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
tardifma wrote:Hi rgn_g.
In the sequential file stage, there is an option named: "First Line is Column Names = False". Change it to True.
And in the Format tab of this stage, you can specify which delimiter you want. You can choose "None", "Comma"... or you can even type it is the list... ; for instance...
Hope it helps.
Mathieu
Thanks!! for your help .It was right in front of the eye yet I overlooked.Appreciate it
Hello Mathieu,tardifma wrote:Hi rgn_g.
In the sequential file stage, there is an option named: "First Line is Column Names = False". Change it to True.
And in the Format tab of this stage, you can specify which delimiter you want. You can choose "None", "Comma"... or you can even type it is the list... ; for instance...
Hope it helps.
Mathieu
I have a similar question.What you said above solves column not appearing problem,but does not add the dilimiter to the first line containing the column names even after adding delimiter in the format tab.
Please help
Thanks
Giri Narayanan