Missing Data - Input Data / Dynamic Input / Dynamic Rename

[james_swanson]

Hello Community!

My workflow contains 1 xlsx workbook with 16 tabs and I have successfully consolidated the tabs into the workflow from 1 input, however, we are missing rows of data from some tabs. What could I be missing in the configuration set up?

Here is the front end of the workflow design:

Input configured to list sheet names:

Dynamic Input tool configuration:

Dynamic Rename configuration:

Looking forward to your input!!

[ckaushik001]

@james_swanson , if the number, order, position and names of the columns are same in all the sheets in your excel file, you can safely remove the Dynamic Rename tool. Headers will be picked automatically by the Dynamic Input tool as per your current configuration. There is no need to use Dynamic Rename tool.

Also, ensure you're using the correct input data source template in the Dynamic Input tool. It should be one of the sheets in your file.

Check the attached sample workflow.

Thanks!

Chanda

[james_swanson]

Thank you @ckaushik001 ! I see your point, however, I was using dynamic rename to rename column headers from row 1. What would you recommend using to replace the column headers in place of the dynamic renaming tool?

[james_swanson]

Also @ckaushik001  putting the row 1 column headers aside, with the dynamic input tool I am still missing rows from some tabs... 🤔

[ckaushik001]

@james_swanson , can you please share some sample dummy data or workflow to investigate further?

[james_swanson]

@ckaushik001 sure thing! Thank you in advance

Input file - Forecast (sample ID 501415 is the key ID that is missing in this workflow, although it appears under tab MATT on Row 111)

Workflow - Generates consolidated information from all tabs but missing ID 501415

[james_swanson · Accepted solution]

Figured it out - it was not configured correctly in the Dynamic Input tool. I selected a template that had fewer rows than a few other Tabs and my start data input value was incorrect. Once I aligned this, the data pulled in full!

Thank you @ckaushik001 and @acarter881 for the assist!

[acarter881]

Great to hear @james_swanson. You're welcome.