Hi Everyone. Greetings of the day.
I am currently working on a process which has the below requirement.
I am taking data from excel file which contains TaskId and document numbers associated with it. For each taskId there will be multiple documents. and for each document there needs to be done some operation on Mainframe. After that transaction will be completed for each document under same taskid. I am attaching the excel screenshot for better vision. I am facing challenge in processing the transaction under same document as there are multiple same documents also.
Please help me in this process. Thanks in advance.
Now use for each row to loop through the TaskID of each row in dt2
Inside it use filter datatable activity for filtering the dt1 with the TaskID
Now the output of filter datatable activity would be datatable which contains only given the given taskid details , u can store the output of filter datatable activity in dt3
Now u can loop through dt3 to loop through each row of dt3
I tried with filter data table but i am not sure exactly how to filter it.
And also i have the requirement for below operations
I have to read the whole excel sheet . Every column data should be fetched and pasted in mainframe automation.
Then i have to check how many documents are there under same TaskId (as per attached screenshot) . Then have to again perform actions for the different documents under same taskId in mainframe.
I understood the process what you have demonstrated in the workflow.
But one more logic here is according to the attached screenshot,
i have to loop through every row and column in the excel sheet , because each data is needed for mainframe, then for same doc under same taskId have to pick all column values like(broker name, invoice number, bus ref) etc.
Thank you very much for your idea. i was able to perform actions for each document under same TaskId.
However few challenges are there in which i am facing difficulties. Below are the lists
for each document under same id there are multiple transactions.
some times the data are same some time different.
in mainframe operation there should be entered the taskid once and total amount once but the once after entering the net amount again receipting needs to be done under same taskid without iterating the same document again.
I have attached the Excel file with exact data for more clarification.
Please help me in this scenario.
The same document number should be read once under one taskId. Then for the same document multiple operations would be there (as you can see in the attached excel file, there are different invoice number, different clients for one document. )
Once all the operation are done for every invoice number under one doc then only it should move to second document under same taskId.
Please let me know if i was able to explain the scenario
@NIVED_NAMBIAR ,
Filter part i have already done as you described in previous reply.
But the next scenario is, the same doc has multiple invoices so have to perform operations more than once for a same doc .
(Attached excel file has the clear data and demonstration)