How to use dynamic input to import the data including the first row data?

I am currently using dynamic input tool and input tool for tab names to import an excel file with different tabs. However, when I input them, my first row becomes the header and my other data's first row are just missing ( I think Alteryx think they are headers and therefore eliminating them). I want to import my first row as data as well. How can I do that? I have try ticking the first row contains data in the input tool and it is not working. Anyone can help?Thanks a lot!

Workflow

Accepted answers

benbenjoy

Sorry guys... I think I know the solution. When we input the data source template, we need to tick the first row contain data and then it works!

All comments

LordNeilLord

Hey @benbenjoy

Are you able to share your workflow?

benbenjoy

I do not think I can.... The data contain quite sensitive data...... So basically, I got multiple tabs which contain the employees' compensation data.In the first row of the data, it contains the employee's name and then I need to include that in my data. If I use dynamic input, they do not allow me to include the first row as data and it read it as header.

benbenjoy

Sorry guys... I think I know the solution. When we input the data source template, we need to tick the first row contain data and then it works!

harshitasinghania

I am not getting the First row contains data option in the dynamic input tool. Can someone help please?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703