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.
I am using the Dynamic input tool to read 25 files with same column tile name but in different order. however it error out by complain about the Json Scheme.
and i have found out it is because the column title name are not in the same order even the name is the same.
Is there anyway to let the dynamic tool read per column title name instead of the column order? and the file format is xlsx
As far as I understand it, the dynamic input tool allows you to read multiple files that match a certain template (e.g. columns are in an expected order).
However, this article may help you solve the problem by using a macro: https://community.alteryx.com/t5/Alteryx-Knowledge-Base/CS-Macro-Dev-Reading-in-multiple-files-with-...
The link direct me an error page. can you post the full link here please?
Apologies - I hope this one works: CS Macro Dev: Reading in multiple files with different Field Schema - Batch Macro
Thanks for sharing the batch macro, and it does solved out issue in certain level.
However, we have used dynamic input tools across 40+ workflows and we think will be good to if we can still use dynamic input tool?
in the batch macro > interface designer where you can select to auto configuration by name (wait Until all iterations run)
we can do the same setting in the dynamic input tool?
Nope, unfortunately not.
The macro suggested above is the way I always go in this case.
is there any unknown setting in dynamic input tool? just try to understand more about this tool
so far as I understand this tool has 6 options available for you to select when you open the edit.