I have two tables:
Inbound
key
a
b
Outbound
key
a001
b001
a002
b002
…
a010
b010
Node Inbound Pivot results in 1 row for each key for Inbound:
key
1.0+first(a)
1.0+first(b)
2.0+first(a)
2.0+first(b)
…
4.0+first(a)
4.0+first(b)
I want to add the columns from Inbound pivot to outbound.
But number of columns in Inbound Pivot can vary (today 4 column pairs, tomorrow 10 column pairs; depening of number of records inbound, but not more than 10.
How can I best transfer the data from Inbound Pivot to Outbound?
e.g.
outbound.a001 = pivot.inbound.1.0+first(a)
outbound.b001 = pivot.inbound.1.0+first(b)
outbound.a002 = pivot.inbound.2.0+first(a)
outbound.b002 = pivot.inbound.2.0+first(b)
…
outbound.a010 = pivot.inbound.10.0+first(a)
outbound.b010 = pivot.inbound.10.0+first(b)
Is there a node like colum_exist to verfy if a column exists in Inbound?
e.g.
if exist(pivot.inbound.1.0+first(a) then
outbound.a001 = pivot.inbound.1.0+first(a)
endif
After node value lookup you can see outbound with the correct appended columns from pivot; this works fine.
But I do not know you to transfer these result columns to the above named fields because the number of appended fields from inbound pivot can vary from 1-10 for column a and b.
In the node outbound result I have manually created the result table I need for my example workflow.
