DSXchange

Sort the data, use Stage Variables and collect the data in there concatenating the pertinent columns, reset the stage variables on key column changes, pass to an Aggregator and use the LAST derivation for the concatentated data, group by the key columns. Okay, I'm still trying to implement this sug...

A piece of friendly advice, represent your problem with actual rows and columns. Show exact source data and exact expected data. Your example shows a comma delimited string in the expected results. If this is not what you're asked, then show your example more clearly. Okay, here's the sample input ...

Sort the data, use Stage Variables and collect the data in there concatenating the pertinent columns, reset the stage variables on key column changes, pass to an Aggregator and use the LAST derivation for the concatentated data, group by the key columns. Thanks for taking the time off to read the q...

Okay I have a scenario which i'm having some difficulty implementing. I have a table in the DBMS with the following structure:- Parent Dept Child Dept ----------------------- 1 2 1 3 2 4 2 5 3 6 4 7 5 8 5 9 Now, i have to create a sequential file which has the following structure(lets call it Table ...