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 have multiple files in one folder and trying to input using input tool and using * to input all the files in that folder, but its not working for me as its just taking only one file. Can any one help me with the same? where am i going wrong?
A couple of things to check here. Do all the files you are trying to input have the sheet titled 'Report' (the picture is a bit fuzzy but thats what it looks like).
Another thing to check would be to watch the results window as the input progresses, it may be that your table's have a different schema and thus Alteryx will not input them, but there are macro's to solve this issue available on the Alteryx gallery. I can point you to them if this is the issue.
But essentially you need to input a list (either an excel file or text input for example) of all the full paths for the files that you want to bring in (if this is feasible, maybe not so if you are working with high volumes of files. Select that field in the macro and your off.