Every month I need to download a set of files from a Google Drive. The file name changes each month. Example: "Income_statement_11.30.2023". The first part of the name stays the same but the second part referring to the date, changes. How can I set up a parameter so that I don't need to change the f…

You can use a calculated parameter, for instance: {File path} = "Income_statement_" & format(monthend(today()), "dd.MM.yyyy") EDIT The correct expression is below: [image] Using File path Parameters Should be: {File path} = "Income_statement_" & format(mon…

Can I have a "starts with" or "contains" parameter instead? Where can I find the full list of syntaxis for parameters for me to understand the calculation you have suggested and play with variations? Thanks

Check out these links: EasyMorph | Type system and expressions Expressions [EasyMorph Help] List of functions [EasyMorph Help]

Thanks, but I can't seem to get it right. First, I get an error saying {file name} is a parameter missing in my calculated parameter. Secondly, when using functions like Starts With or Contains, it looks like I still need to include the full file name as the first argument and that won't work beca…

Yes, that's correct, @Jochen_Marquardt . Thanks for pointing it out.

{File name} or {File path} IS the name of the calculated parameter. You can refer to a calculated parameter from another calculated parameter as long as it doesn't create a cyclical dependency. See the example below. calculated parameters.morph (1.7 KB) [image]

Ok, I see. However, the formula of the first parameter might change from month to month unpredictably. Sometimes the date format is different. Sometimes it's just the month's name, sometimes it's the last day of the month. How can I just set the file path as a Startswith condition?

[image] Tomas_French: How can I just set the file path as a Startswith condition? I'm trying to understand your case because it looks like I misunderstood you. So you don't need a precalculated file name, but the first file name (in some particular folder) that starts with a certain text stri…

Yes. I just need EasyMorph to download from the Drive the file whose name starts with "income_statement" or that contains the word "income" in it. Every month a new file will be uploaded to the Drive which will have those conditions in its name. But the name will also contain the date in a format th…

EasyMorph Community - Data preparation professionals and enthusiasts

Using File path Parameters

Jochen_Marquardt December 13, 2023, 6:18pm 6

Should be:
{File path} = "Income_statement_" & format(monthend(today()), "MM.dd.yyyy")

To learn more about EasyMorph visit easymorph.com.