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 able to obtain a compiled data from multiple files using the second macro as illustrated below.
However, I would like the columns identified in the previous functions to be included in the dataset such that "Sheet Names"，“RegExOut2"，“RegExOut3" and “RegExOut4" are included in the first 4 columns. These are obtained from the names of the excel files i.e. Real estates [Data centre] [SGD, RM].xlsx respectively.
Desired output will be as such:
#1 KL DC
#1 KL DC
Thank you so much in advance. Really appreciate all the help!
Hi @zekharya , If you are sending the required fields like sheet name, regex outputs to macro then you can have them in macro output also. Else you can assign a record ID to the rows and then join the macro output in main workflow with previous data on record ID and have the required fields from previous data.