Hi,
I created a workflow that reads multiple Excel files, merges them into one DataTable, applies a filter, and writes the result to an output file.
Problem:
The output Excel only contains the column headers, but no data rows.
Read Range Workbook with AddHeaders=True and blank range.dt_Input into dt_report, then filtering into dt_Filteredreport.dt_Filteredreport to the output file.workflow:
output(only headers):
Expected output:
Hi @Keerthana06
It can be the case that during the merge/filter, data is getting lost/filtered.
I would suggest to run process in debug mode, put breakpoints at different merge activity and filter activity.
And then review the datatable variable in each of those activity from locals panel.
That way you will be able to find out where data is getting lost.
Hope this helps.
Regards
Sonali
Also, what does your dt_input and dt_report contain?
Output of read range is dt_input?
If yes, then what does dt_report contain?
dt_report is a master DataTable where all dt_Input tables are merged
Ok, please try debugging, that will allow you check datatable output after each merge and filter
Mostly filter is removing the data from it..simply use a log message in your second for loop mostly it is not running at all as there is no data
Either run in Debug and check locals panel or add a log message with dt_report.rowcount before and after the filter activity
Alao please check the scope of dt_report if it is inside for then it will be reintialized always and previous data would be lost
Cheers
*Added log messages before and after the Filter DataTable:
From this, it looks like dt_Report has rows, but dt_filteredReport is coming out empty, so the second For Each doesn’t execute. The issue might be with how the Filter DataTable outputs to dt_filteredReport or the filter condition itself.
okay I missed it yes dt_filteredreport is what is to be checked as that is whst is being written and as expected as for loop is not runnign filter is not working..check the same
cheers
I ran the workflow in Debug mode with breakpoints and watched the DataTables in the Locals panel just like you suggested.
Big thanks for the tip – the Locals panel turned out to be a real data detective tool and solved the mystery!
Yes, you were right – I checked dt_Filteredreport and it was coming out empty, which is why the second For Each wasn’t running. After correcting the filter condition, it’s now returning 3 rows and the loop runs perfectly.
Thanks for pointing me in the right direction! Cheers!
Glad to know it helped:)
Locals panel - detective panel 
I like it 
Now that your issue is solved, kindly consider marking the post that helped as a solution so this topic can be closed.
Regards
Sonali
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
