DSXchange

Hi All,

I need to join the headers and traliers of the file.

I dont have any key coloumn on header or tralier. I need to to seperate header , detail records and tralier seperately . And for validating header and tralier records , I need to join them.

Please Advise.

Thanks & Regards,
Kumar.R

Define 'join' in this context. Actually - spell out in words for us (and you) exactly what you need to do with the header and trailer records. Without using the word 'join'.

Whether the Header and Trailer records are in Sequential file? Do you want to merge them into single file or do you want to join them? Send brief description of your requirement.

My guess - though let's wait for the OP to get back - is that the requirement is to compare the number in the header and the number in the trailer.

Hi All,
Thanks for your replies . I need to validate all the fileds in the header and tralier.

Bascially I need to merge the header and tralier record .

For example. my header has 18 fields and tralier has 3 fields. My output should have 21 fields as one row.

Please Advise.

Thanks & Regards,
Kumar66.

In an External Command Stage, use the following Source program:
replace <FilePath+Name> and <Delimiter> with the appropriate text.

HTH.

Or, indeed, in an External Source stage.

ray.wurlod wrote:Or, indeed, in an External Source stage. ...

Whoops!!! Typo!!!

Thanks Ray.. thats what I meant to say!!!

Hi All,

Thanks once again. I need the header fields 18 and tralier fileds 3 as one row.

Now my requirement has changed and I have a key filed in the header and the tralier.

Is this possible if I use a full outer join making a key filed in header and tralier?

Please Advise.

Thanks & Regards,
Kumar66

Yes, but why not use an inner join? You can readily enough isolate those rows (perhaps with head and tail stages).

Hi Ray,

Thank you very much. I will go with the full outer join.

Regards,
Kumar

use Column export stage for this to get 21 fields

and use funnel stage before column export