Dynamic Input Same Schema Sheets Error

Hi,

Please see attached screenshots, I am bringing in 5 different sheets from the one excel, with the same schema, for some reason no data is outputted from the dynamic input tool. For the 'Input data source template' I am using the first sheet in the excel.

Any clarification would be appreciated.

Thanks

Daniel

image.png

Developer Tools

Accepted answers

All comments

dougperez

Hello!

Are you creating the full file path (c:/users....filename.xlsx|||sheet) or just the filename?

apathetichell

Usually it's just a straight input data/select sheet names option - straight to dynamic input where that field is brought in.

Can you clarify why you're using formula to change the path in-between?

danielmaguire

Yes it is the full file path! See snippet below

image.png

danielmaguire

The formula is brought in as using the input tool, the output is <List of Sheet Names> so i replace this with the actual Sheet name, see snippet below!

image.png

danielmaguire

Thanks all, I have found the solution, the input data was not in the same schema, as some of you have suggested. I have amended this and it works find now. Thanks All!

atcodedog05

Glad to hear it worked @danielmaguire 🙂

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335