DSXchange

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

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.

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

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?

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

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

Hello 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

HI Giri,
Delimiter setting is not different for Header and detail. If your detail data has comma delimiter, your header should also hold the same. Pls check the setting once again.