If the data is filtered, how to save the particular column data which is filtered and use that value to filter in another excel.
you can loop the filtered data table in your next filter data table.
example: already you used one filter data table activity. currently you have filtered value in data table.
you can reuse the same column value in another filter data table with using for each row data table activity.
I cant understand the logic
please find the below sequence for reference.
Sequence1.xaml (15.6 KB)
hope its clear to you
by filter activity , I have filtered the empty values, I should store the name value in a variable and store that in a variable , with that variable I should filter that value in another excel file.
How to do that?
yes, if you use filter data table activity to filter total column with zero value. it will be stored as with name column value with hyte and total column with zero . again on another filter data table you can filter the value using with help of foreach datatable activity ( currentrow(“name”).tostring"
1 Like
Please mark it as solution. If its helps!!!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.