So i have 2 tables - Input1 and input2 as follows –>
Input1 is feeding into a loop and creating input 2. once the input2 is completed, i wan tot join input1 and input2 whihc i trying to via merge.
The issue is that when i am joining it, 2 issues are happening –> 1. the data is not joining 2. I am not getting all the columns from both the tables
Attaching both tables and the merge output below below
input1 –>
Input2 –>
merge –>