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 getting below file paths from directory tool.
Want to combine the data of two files and generate single output.
Example combine data of "MI_ABC_19072019_1608.xlsx" and "MI_ABC_19062019_1430.xlsx" and generate one output.
Similarly combine files "BB_PQR_XX_19072019_1553.xlsx" and "BB_PQR_XX_19062019_1535.xlsx" into one output file. Also combine "MI_PQR_19072019_1533.xlsx" and "MI_PQR_19062019_1543.xlsx" into one output file.
Looks like your filename will be the best candidate to tackle this - there is a designated field in the Directory tool output with filename only.
You can use regex like this:
The final workflow looks like this - following this is suggest to get a macro that will take every record (groups of files to be combined and read them from 2 inputs and assemble the results accordingly and bring back to the main workflow).