Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have data like below i want to compare primary and secondary in lookup table template id,if both primary and secondary matches with template need to combine element a+b or if only primary matches need to get only a or secondary only matches need to get only b. can some one please help me on this?
Main Flow:
Primary Secondary
1 2
3 4
Lookup:
template element
1 a
2 b
Output:
Element
a+b
If you download v7.1 you should be able to see how this job works and recreate it in any version you are running.