Join Output of 2 Select statement in 1 for output

[rohit782192]

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.

Input1	Input2	Expectation(OUTPUT)
Select1	Select2	SELECT
1	INDIA	1	INDIA
1	CANADA	1	CANADA
3	AFRICA	3	AFRICA
3	US	3	US
3	MEXICO	3	MEXICO

[DataNath]

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.

[rohit782192]

Bith are Different Select Statement Output

[binu_acs]

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