AnsweredAssumed Answered

Complex XML to flat table

Question asked by Erfan Ghasemy on Aug 22, 2018


Hello everyone,

 

I'm trying to transform a complex xml file to a flat table. Attached is a sample of what I'm working with.

 

When I run my transformation, it ignores every detail of the next country_group_def, but it adds all the countries from it to the first one. What I need is it repeats the country_group_def for every iso_country_code that's inside that country_group_def.

 

Any help would be highly appreciated!

 

Erfan

 

Attachments

Outcomes