DSXchange

you can try this. Use the below combination of data for 2 links, one source and another for reference. Source Data. SRC_KEY ,SRC_NK ,SRC_KEY 1 A 1 2 B 2 3 C 3 4 D 4 Reference Data: SRC_KEY_1 ,SRC_NK ,SRC_KEY 1 A 1 2 B 2 3 C 3 4 D 4 Use a Full outer join on the data. SRC_KEY ,SRC_NK ,SRC_KEY_ref,SRC_...

Hi, You can do it like this, as you said they are fixed files, so split the data accordingly based on the field lengths and sort the data in both the links[ source and reference] based on the same order of field keys, now this makes the data comparision easy. In the Left link create a "Dummy&qu...

Hi, I think there needs a small correction as the string in which we need to search should be the first argument, please correct me if i'm wrong. Earlier posted: Index('|ARC|PPD|CCD|CTX|COR|DNE|','|':lnk_xfmr_target.CLASS:'|' ,1 ) Corrected: Index('|':lnk_xfmr_target.CLASS:'|','|ARC|PPD|CCD|CTX|COR|...