DSXchange

Hi there I have a Master data set with which I do comparisons with a Reference data set. The issue I'm having is that the Ref data set contains only substring info of the keys used in the Master Data set. Assuming that I'm only showing Key values for the two Data Sets: Master Data Set ------------ A...

But isn't the effect of applying a "Sort Merge" on the Sequential file taking multiple partitions and merging them into one single list before ordering that list? At the end of the "Sort Merge", I'd expect a sorted list (with possibly repeated rows). Does the Unique option on the...

Hi there Hope your day is going well. I've got a Sequential File with a column that I'm wanting to remove, and then get a Distinct across the remaining columns. i.e. Data looks like (4 columns, space is delimiter) ColA ColB ColC Prod 1001 A 1 Prod1 1001 A 1 Prod2 1001 A 1 Prod3 1001 A 1 Prod4 I'm wa...