Forum Discussion
Solved
Get only specific data from each file
Hi All, I am facing the following issues I cant solve. I have a folder with multiple excel files which have the same data but for different data ranges. So as a data source I have the folder....
Quick update:
I have managed to resolve this by following this:
and using the transformations from the first post.
Hi FrankAT ,
many thanks for the response!
Not sure if I got it wrong or didnt summarize my request correctly.
If I go with this solution this will work for the file I have uploaded today, however if it tries to filter a file from the 2nd of October (there we will have data only until the 1st of October) this wont work , I assume?
Many thanks!
Best regards,
Ivan
Quick update:
I have managed to resolve this by following this:
and using the transformations from the first post.