Ho together
After searching the forum, I've not found something similar. Maybe someone can help me.
I am trying to import data from an xml-file.
With the "Utility XML" I can get a collection from the key elements by filtering with ""ns3:Key".
The same for the value elements by filtering with "ns3:Value"
To do that, I need two different collections with a Field Name defined by "XML". Otherwise the "Get Elements" Function will not work.
I do now have two collections with the same amount of rows, which represent the keys and the suitable values.
How can I now get this information together in a proper way? I need to fill up some variables. I see there many possibilities with loops, but I think there will be a more intelligent way. When I will merge the tables with the "Collection Manipulation" Utility, there is no way, because of the same XML field name.
Thanks for your ideas!
Regards
Stephan
After searching the forum, I've not found something similar. Maybe someone can help me.
I am trying to import data from an xml-file.
With the "Utility XML" I can get a collection from the key elements by filtering with ""ns3:Key".
The same for the value elements by filtering with "ns3:Value"
To do that, I need two different collections with a Field Name defined by "XML". Otherwise the "Get Elements" Function will not work.
I do now have two collections with the same amount of rows, which represent the keys and the suitable values.
How can I now get this information together in a proper way? I need to fill up some variables. I see there many possibilities with loops, but I think there will be a more intelligent way. When I will merge the tables with the "Collection Manipulation" Utility, there is no way, because of the same XML field name.
Thanks for your ideas!
Regards
Stephan