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
MarcelBeug's avatar
MarcelBeug
Community Champion
9 years ago

Probably the name of an old file is hard coded in one of your queries. Prime suspect would be a query "Sample Binary", which is one of the objects created when the "Combine Binaries" functionality is used to combine files from a folder.

 

You can adjust that code so it points to the first (selected) file in the folder.

For instance:
SampleBinary = Source{0}[Content]

where "Source" is the name of the previous step.

 

This behaviour was adjusted (for new combine binaries) in the May 2017 upgrade, as follow up on an idea raised by yours truly.

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!

  • MarcelBeug's avatar
    MarcelBeug
    Community Champion
    9 years ago

    So "Quelle" is your previous step and the solution would:

     

    let
    Quelle = Folder.Files("C:\perfdata"),
    SampleBinary = Quelle{0}[Content]
in
    SampleBinary
  • 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?