I have divided my RDA functionality into 6 sequence files means 6 .xmal files.
Through REF under process transaction I’m invoking to my first 1 file out of 6 files.
The 1st file is reading an Excel file through invoke activity and creating output datatable and then using a for each loop and getting row data from column A which has ID.
(In excel file i read the file and getting sheets data from read range and putting into an output variable).
This loop is reading ID one by one…
Then i do other activities and invoke to 2nd file/sequence.
In 2nd i use invoke to go to 3rd file… and same with 3 to 4 file.
Let say I’m in 3th file and still in same for each loop and its working fine that im using same ID 1,2,3 and working on being in same ID.
Now i use invoke again to read excel output variable and now i want to read another column price…
I do the same after invoke i create output debatable and reading the read row B which has price.
Then i do other activity and in typeinto activity i want to put price of same ID.
Note…I same file i use 2 other column value from excel and its giving the right value.
I am in loop of ID… l’m on ID 3 and i expect it should show me price of ID 3 but NO its giving me the price of ID 50 which is the last ID of this column.
Now problem is… its not giving me price of same ID and question is why?
Can someone tell… what i wrong and why its showing the last ID price rather then the price of 3rd ID?
What i have did wrong and how can i correct easily.
I can not create one big file whole process as it has many activities.
Kindly help. Thanks.