Complex XML output generation

Paul M · Post by **Paul M** » Mon Nov 20, 2006 4:36 am

I'm trying to write complex XML output using the XML output stage. The information comes from different tables (customer, address, contacts = phone numbers). Since addresses and telephone numbers can be mutiple for 1 customer, they must appear in repeating groups in the XML.
My question: how do I produce such an output? Given 1 customer, I could do a lookup for the addresses, but then I could get multiple results in the lookup, how do I merge them into the main customer flow to get 1 XML output message? Anyone with a good suggestion?

Thanks in advance, Paul Mulder

ray.wurlod · Post by **ray.wurlod** » Mon Nov 20, 2006 7:47 am

Welcome aboard, Paul.

Can you please confirm that you are using DataStage TX (also known as Mercator, also known as "transformation extender")? If you are using some other variant of DataStage, the answer will be completely different.

Paul M · Post by **Paul M** » Mon Nov 20, 2006 10:09 am

OK Ray, I guess I've posted this message in the wrong forum. I just use Ascential Datastage 7.5 with XML extention package. I'll try to find the right forum, thanks for your hint.