I have a table DT_TempInTable(read from excel spreadsheet).
For each Row in DT_TempINtable
filter table by some condition-stored to DT_Tempouttable
For Each Row in DT_TempInTable
filter by some condition-store the result back to DT_TempinTable
Here result is stored to DT_TempINTable but when the loop comes to the main for loop ,the last stored data in DT_TempInTable is not shown rather the left over of the first loop is seen.Is there any specific syntax to assign the table?Please advise.
Thanks for the reply.sorry i cant attach the workflow…due to compliance issue.I am getting the desire output in TempinTable as i can see the row,col value in locals pane.
Looking at your workflow it seems you have filtered same table i.e base datatable multiple time which is DT_TempInTable and you final result is stored in DT_ResultantTable
So do you mean you are not getting value in DT_ResultantTable?
Also, i do not see your workflow assigning back in the base table
this one, instead your final table should be ResultantTable
It would be easy for you to understand the flow if you use Workflows it will keep the code clean and organized and then you can Invoke workflows wherever you want
Basically once i use the data in resultant table ,i need to loop back to the Tempintable where i am removing all the rows which i have iterated at the begining of the for loop,eg:say remove rows which contains value “Apple”.The output after this filteration is stored into a newtable which is stored back to TempIntable and so on the process continues till the rows are zero.Hope am clear now.