Forum Discussion
Helper ILoad/combine multiple files, but only the keep data from most recent
I have used load multiple files from folder; however; some of the data overlaps and I am only interested in the most recent data. Each row corresponds to a date across files. Some of the newer files list previous dates but have updated data. What is the way of handling this issue.
3 Replies
Hi jberman,
Can you post some data from the qeury editor, where we could see what kind of files you are working with?
Are you trying to only load most recent files or all files? Do your files have a field for "last modified" etc?
Br,
T
jbermanUsing the data above, I am interested in grabbing the data in the bottom row (from the most recent file) for the DATE July 8,2018 and "Group" segment. I had tried the Group by function was not successful is allowing all columns to be grouped by the "Source Name" at the time.
jberman Thanks for the data.
What I'm having trouble to understand is why you need to import the old files as well. Why not just import the latest xls file so you don't have to worry about old data? Beofre expanding the files you could sort/filter them according to the latest modification date , remove duplicates etc..
Based on your requirements, you could just filter segment=group and filter the source to be the latest and get the row higlighted in yellow.
Br,
T
