Hi Shiva,
I did ..something again.
1. Group To List everything in the begining. Why? Because I dont understand but now it doesnt give any error message.
2. switch with all relevant lists
3. Order join step: Right : which has value all the time (parent) Left : child
both of them from switch
What did I get from this one to many XML?
many lines, where the one row source had only once a row.
If we have 1 row from parent, 3 rows from child:
Parent will be filled only once. BUT! The xml keys can be multiplied! So we are safe.
Parent , child, version, concent,sysdate, key1,key2
---------------------------------------------------------------
PID1,CID1,34,DarwinPrice,2019-04-13...., realkey1,realkey2
NULL, CID2,34,DarwinPrice,2019-04-13...., realkey1,realkey2
NULL, CID3,34,DarwinPrice,2019-04-13...., realkey1,realkey2