Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


kvenugopalan
2018-12-05T22:43:37Z
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
Sponsor
Forum information
Scroll to Top