transfering pivot output with differnet number of columns using vlookup
Dear all,
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
Please find workflow attached.
Thanks for help!
BR,
Heinz