Combining dataset from macro to include columns identified before the macro

Question

Hi all,

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:

RegExOut2RegExOut2RegExOut2Sheet NamesF1F2F3...Real estatesData centreSGD, RM#1 KL DC2015-09-012015-09-300Real estatesData centreSGD, RM#1 KL DC2015-10-012015-10-310

Thank you so much in advance. Really appreciate all the help!

zekharya · Answer

Thanks Sapna, is it possible to put a macro within a macro as illustrated below? (i.e. putting 2 macros side by side not linked to one another)

I am currently still figuring how to make them work. Thanks for the help!

grazitti_sapna · Answer

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.