Output from aggregator & xformer to single sequential ta

Kel · Post by **Kel** » Mon May 11, 2015 10:08 pm

I have 3 input links: 2 from aggregator stages and 1 from transformer that must be moved to a single target file. What would be the stage to be used? We cannot use funnel since fields are all unique. Responses will be very much appreciated.

ray.wurlod · Post by **ray.wurlod** » Mon May 11, 2015 10:43 pm

I wonder if you could use an External Target stage using the cat command and runtime column propagation, and a collection algorithm that exhausts each input before moving on to the next?

qt_ky · Post by **qt_ky** » Tue May 12, 2015 9:22 am

You could concatenate all columns and delimiters from all links into a single varchar column then funnel them into your target file.

ray.wurlod · Post by **ray.wurlod** » Tue May 12, 2015 3:59 pm

This (qt_ky's suggestion) is the exact purpose of the Column Export stage.