Forum Discussion

heidi_andrew's avatar
heidi_andrew
Contributor
3 years ago

File Operation snap question

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?

1 Reply

  • marjan_karafilo's avatar
    marjan_karafilo
    Contributor

    Hi Igor,

    Then maybe Group by fields snap is the one you are looking for?

    You can choose by which object to group by.

    Let me know if this helps you.

    BR,
    Marjan