Sorted Import from Flat File

[Kent1341]

Hi 

I receive flat files once a month over the last 2 years' sales. However, there might be some changes to the data that have occurred since the last time I got the data. Therefore I need to make sure that I have the latest data in my model.

So after I have appended them I Remove the Duplicates from the file. So far so good.

But Is there a way where I can sort my data and say "I want to import this data and after this, I can take this data"?

Best Regards Kent

[Kent1341]

Thanks Ibendlin,

I managed to take out the lines that I needed instead. 

Br Kent

[lbendlin]

For that to work you need two data points

- a unique transaction identifier

- a "modified"  timestamp for each row (unless you can proxy that with the file name or file date  for your files)

I would recommend against any attempt at sorting. Handle it via DAX .