Hello, I’m new to DataServices and I have a problem when I try to run this job. I have 2 excels (Charge_Grunddaten and Charge_Klassifizierung)
Each excel has 10 lines. When I run the job, it will create 100 batches, I’m guessing is multiplying 11, 12, 1*3…and so on. I have a unique column named ‘RECORD’ but if I try to do a join between the 2 Queries I receive an error when doing the final check saying that the column ‘RECORD’ does not exist in the mapped table of RFC function call. I also have a nested table in one of the Queries because I need to input in one field 2 parameters.
I know why I have the error, column ‘RECORD’ is not in the structure of the table in SAP. My question is, is there a way to tell DS to take 1st record from the Charge_Grunddaten and the 1st record from Charge_Klassifizierung then the 2nd etc. and in the end I should end up only with 10 batches in SAP.
Thank you for your answers,
Much Appreciated, Dan
nemesdan (BOB member since 2018-02-09)