Search found 3 matches

by RohitNara
Fri Sep 18, 2009 3:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sort records and put Null if there are more matches on key
Replies: 8
Views: 4203

Re: sort records and put Null if there are more matches on k

what if
Location Timezone
1000 CST
1000 PST
1000 NULL
this kind of data occurs???
by RohitNara
Fri Sep 18, 2009 3:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sort records and put Null if there are more matches on key
Replies: 8
Views: 4203

Re: sort records and put Null if there are more matches on k

what if
Location Timezone
1000 CST
1000 PST
1000 NULL
this kind of data occurs???
by RohitNara
Thu Sep 17, 2009 6:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unique requirement to combine two files
Replies: 9
Views: 4123

Re: Unique requirement to combine two files

Hi, I have a requirement to combine records from two input files, none of which is a Master. I want records from both merged, but on the same line. Input file 1 53,red 53,blue 55,black 57,orange 57,violet Input file 2 53,boy 53,cat 53,dog 54,pig 55,rat 56,girl Expected Output is 53, red, boy 53, bl...