Input Multiple Excel sheets with a Dynamic Input tool doesn't work

[Florfbonfran]

Hello Community!

I have this problem. I use the Dynamic Input tool with the excel attatched (prueba food.xlsx). I tested with two sheets, CD and CREG. These sheets have the same fields but I have the following error:

I configured this:

I did a dummy test with another short example and it worked perfectly but I can´t do with this..

Could you help me? 

Thank you!!

Regards, 

Flor

[JosephSerpis · Accepted solution]

Hi @Florfbonfran you issue is column Z in the CD tab there is text "queda igual" in the column which Alteryx is reading the whole column as a string field. Where in the CREG tab it's blank and Alteryx is reading in as double field. This is why the dynamic input tool is not working. I deleted the column and the dynamic input tool worked. 

[Florfbonfran]

Thank you very much! @JS420 I had a lot of sheets and I didn't see that! 

[JosephSerpis]

Hi @Florfbonfran just for reference I used the field Info tool to work out the difference in field types between those sheets.

[Florfbonfran]

Oh, I didn´t know about this tool! I tested and I could see the error too! Thank you !