Forum Discussion

Kent1341's avatar
Kent1341
Helper I
4 years ago

Sorted Import from Flat File

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

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    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 .

  • Kent1341's avatar
    Kent1341
    Helper I
    4 years ago

    Thanks Ibendlin,

     

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

     

    Br Kent