Thank you @flying008 @KGT @alexnajm for your quick responses. I analysed the Union Tool and found it to be working.
However, I think the solution that I thought about, in itself is wrong. I do not know whether I will be able to clearly explain what I need but let me give it a try.
As of now, there is no key.
I have a requirement to extract 52 columns from SAP. I am using DVW Read Tool connector to extract the data. DVW is unable to handle so many columns.
Hence, I decided to split this 52 columns into 4 equal parts in 4 DVW Read Tool. In otherwords, the 52 columns is split into 13 columns per DVW Read Tool.
The data is now extracted properly but there is a problem.
Imagine there are 4 rows and 8 columns
Columns - Customer, Customer Name, Customer Address, PO Number, Vendor Number, Vendor Name, Invoice Number, Invoice Date
Each DVW Read Tool will contain 2 columns each
DVW Read Tool 1 = Customer, Customer Name
DVW Read Tool 2 = Customer Address, PO Number
DVW Read Tool 3 = Vendor Number, Vendor Name
DVW Read Tool 4 = Invoice Number, Invoice Date
The Read Tool extracts the data without any problem.
However, what I think is happening in the background is this
The first Read Tool reads the first row of the data and extracts Customer & Customer Name but it will not extract the other columns
The second Read Tool and I think this is what is happening in the background, will read the next row instead of Customer Address and PO Number of the first row.
Even if the Union tool works, the data is not correct.
Ideally, I want the Union Tool or any other method, to merge all the 4 Read Tools.
It must get the Customer, Customer Name from the first Read, append Customer Address, PO Number from the second Read, append Vendor Number, Vendor Name
from the third Read so on and so forth thereby creating a single line per record.
Since, all the 4 Read Tools, I suspect this is what is happening, read 4 individual lines, this solution will not work at all.
Hopefully, you can understand
