This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Do you use Alteryx in a language other than English? If so, we want to hear from you! Please help us improve the international experience of our products by participating in this 5 minute survey.
We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.
I have a shared folder which has files which are manually created in a shared folder like below, I need to read the COB file and compare it with previous file and create reconciliation exception output with today's date.. Could you help me?
I tried using input tool using *, remembered this from my core exam and dynamic input tool but it gave an error and skipped file, what do I need to do in dyanmic input tool?
You would need to create a batch macro for your input files if the schema keeps changing, I would advise this especially in cases when someone is creating these files and they are not coming from a system. How do you read multiple files with varying schema is available here below:
In your case you'll need a date formatting on file name and finding latest and latest-1 file details before passing the output of directory tool to the macro shown in the post above. Something like this should help
Once you are done with all your functions, configure your output tool to create a new sheet using a field, create that field using formula tool
Look at the configuration shown above on how output tool is configured. Hope this helps! 🙂