I have built a solution which reads two Excel files, storing all values in a data table and then filter for a given value and then append the values to a file.
Is there any way i could manage this with write to file at the end of my solution?
If so a need to find a way how to add the values to a data table instead of overwrite the values in each loop.
Do you have any suggestions? I have added my solution with ‘Append Range’ which works fine, but i would like to have input if there is other ways to solve it.
Main.xaml (11.4 KB)