I am using Dynamic Input tool to pull data from multiple tabs in one file. For some reasons, data from one tab wasn't pulled in my workflow. Is there anybody came across the same issue? How to fix it?
Thank you!
Hi @HaiNguyen this typical because the schema is different which can be the result of a single cell being different say a numeric column becomes Alpha numeric. Hence a Batch Macro is generally the best approach as it can still pull data when the schema changes and they you can build checks to ensure a numeric column has numeric values. This article explains in more detail.
Can you give an example of how your Dynamic Input is set up?
Awesome. I reformatted the missing data tab to be the same as the others, then it worked. Thank you!
Mine was set up very simple. I used Input data tool to pull the list of the data sheet then used the Dynamic Input tool to pull data from all the tabs in the sheet.
