Unable to match file name pattern

  • 82Views
  • Last Post 03 March 2022
0
votes
Akin Gumusel posted this 03 March 2022

Hello,

I have a scenario where I am exporting some records from Salesforce to a csv file in sftp server. I do use the data flow to generate the files with a name pattern. I use the following pattern:

'AccountSkyvia_' + string(year(get_utc_date())) + '_' + string(date_part('mm', get_utc_date())) + '_' + string(day(get_utc_date()))

  And this generates a filename like: AccountSkyvia202233.csv   The problem starts here, I do need to tag those records as exported, thus I want to run an import task after this again specifying a file name pattern. But I can't seem to match the file using AccountSkyvia{mmddyyyy}.csv. Not sure what I am supposed to use there.   Any help is appreciated in solving this. Thanks  

0
votes
Akin Gumusel posted this 03 March 2022

Please disregard this ticket. I was thinking Skyvia was not accepting the "m" Month identifier in the import task, but it was due to mismatch in the day identifier. 

Close