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 attaching 3 sample files which have different schema, i would like to combine them into one excel file as output. Please help me with the workflow which could automatically read all the files from the folder and combine them.currently i have only 3 excels in the folder , it may increase in future from 3 to 5 .
Do you envisage many more files being generated or will it remain a handful. If you think it will only be a handful I would just create an Input tool for each file and use the "Start Data Import on Line" property to appropriate number for each file.
If you want to make it fully generic where new files can be added to a folder and the data section can start at any line you will need to think about a macro that scans the files to find the appropriate number of rows to skip and then import the data.