Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Datasource CSV File Folder > Delete old Data creates expression.error

Hi There,   I have 2 different Folders with CSV Files for every day.   Folder A > A-2017-01-01 > A-2017-01-02 Folder B > B-2017-01-01 > B-2017-01-02   This files in each folder are merged ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi MarcelBeug,

 

sorry for the late reply.

 

My "SampleFile" looks like this in advanced editor (german, Quelle = source):

 

let
    Quelle = Folder.Files("C:\perfdata"),
    #"C:\perfdata\_perfdata_2017-04-05 csv1" = Quelle{[#"Folder Path"="C:\perfdata\",Name="perfdata_2017-04-05.csv"]}[Content]
in
    #"C:\perfdata\_perfdata_2017-04-05 csv1"

But I dont have any other previous step, so how should I do this here?

 

Thanks for any hint!

CahabaData's avatar
CahabaData
Memorable Member
9 years ago

This interests me.  Let me see if I understand your issue generically: your source file(s) name(s) is/are regularly changing (we assume the structure is always identical)... 

 

and so are you invoking the Refresh or are you changing data source and doing a new Get Data?