I want to do the file compare (DIFF) on two files but the name changes every day with a new date. On my File Reader snap, I have put the file names in like this
“smb://xxxxxx.com/us_data/Shared/MM365/Clients/Small Market/Reporting/Non-Standard_Reporting/xxxxxxx_CUSTOM_FILE/SNAP_PAREXEL/xxxxxxx_Custom_Report_” + Date.now().toLocaleDateString({“format”:“MM_dd_YYYY”}) +“.xlsx”
the excel parser is throwing an error on this function. I need to compare the files on a daily basis. The files are written out with today’s date. How can i set up a pipeline to read these files and compare them to yesterday’s results? The file name will change daily. Any ideas?
