Question Re: Dynamically create target xml nodes based on the source fields in Technology Q&A

Dynamically create target xml nodes based on the source fields

pi_consultant1 — Wed, 18 Oct 2023 06:25:11 GMT

HI Experts,

I have the following Source structure:

The Fields can be more than 5

Ive to create the following target structure:

Can you advise how to dynamically create target XML nodes based on the source xml fields, starting from name4/value4?

Thank you in advance,

John

Re: Dynamically create target xml nodes based on the source fields

fprokopiuk — Wed, 18 Oct 2023 19:35:22 GMT

Is the input structure dynamic? From your example it doesn't looks like it so you can simply map it manually. For each new name/Value create new Test instance on receiver side and map corresponding source Field to Limscode/Value. To choose name use CopyValue(1) and for value use CopyValue(2) - both with context changed to Tests level.

So something like:

Test(1)
Field4 (context Tests) ---> CopyValue(1) ---> Limscode
Field4 (context Tests) ---> CopyValue(2) ---> Value

Test(2)
Field5 (context Tests) ---> CopyValue(1) ---> Limscode
Field5 (context Tests) ---> CopyValue(2) ---> Value

Test(x) - add as many as you need for the input structure
Field(x+3)(context Tests) ---> CopyValue(1) ---> Limscode
Field(x+3) (context Tests) ---> CopyValue(2) ---> Value

Re: Dynamically create target xml nodes based on the source fields

pi_consultant1 — Thu, 19 Oct 2023 08:58:41 GMT

The source structure is actually a csv file, with the first line the name of the fields (so name1, name2,...) fields and the second line are the values (value1, value2,...), the place and the number of the values can vary everytime.

So I would like to create the target fields dynamically, I made them now manually. So Im wondering if this is also possible dynamically and how to achieve that.

If you have an idea please let me know.

Br,

John

Re: Dynamically create target xml nodes based on the source fields

fprokopiuk — Thu, 19 Oct 2023 22:33:05 GMT

OK understood, you can then try to follow this blog: Message Mapping : Play around with target structure