Join Output of 2 Select statement in 1 for output

Question

Hi,

I have 2 Select Statement fro Workflow . For Output purpose i have to join the 2 Select Statement,

I Tried using Union but i am getting Null and then the Output.

Tried using Record id but join is not giving Expected Output.

Below are the details.

Input1Input2Expectation(OUTPUT) Select1Select2SELECT1INDIA1INDIA1CANADA1CANADA3AFRICA3AFRICA3US3US3MEXICO3MEXICO

binu_acs · Answer

@rohit782192 If there are no common keys to join you can use the join by position option in the join tool

rohit782192 · Answer

Bith are Different Select Statement Output

DataNath · Answer

Hey @rohit782192 - I may be missing something here but it looks like you want to just use a Join tool and hit the ‘join on record position’ radio button at the top of the configuration. If not, I think we’ll need some more context/explanation here.