XML 2 same tags,same attributs but the value differents

[jwiles]

A slightly different visual to show you what Ernie described earlier with your first data example. What you will get on the output link is this:

Code: Select all

COLUMNS ----->  language     productMetaTitle
ROWS/VALUES ->  en-US        NECTARINES 1 KG
                en-DE        differents value2 here KG

At this point it's like dataset with two rows of data. Pivot it if needed, or whatever else you think you need to do. The distinction Ernie pointed out is very important because it's affecting how you are interpreting what you think DataStage will do.

Regards,