Hello, We have a vendor data pushed to a single folder that contains multiple dated files like for example, \Account Reference would contain
Account_Reference_20181205_000242312_95588628.csv
Account_Reference_20181204_000302159_95560005.csv
Account_Reference_20181203_000235243_95535765.csv
To initiate the load process we need to figure out the file with the recent AsOfDate in this case 2018-12-05 and the pattern search the directory based on "20181205" to check if the file is available.
Also I would probably need to store the AsOfDate and the file name (determined by pattern search) within variables so I can pass that to the underlying job. I am new to Visualcron so appreciate if you guys can guide me on this scenario.
Regards,
Kishore