Missing Data - Input Data / Dynamic Input / Dynamic Rename

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!!

Workflow

Settings

Help

Accepted answers

james_swanson

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!

All comments

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.yxzp

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

Thank you @ckaushik001 and @acarter881 for the assist!

acarter881

Great to hear @james_swanson. You're welcome.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703