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

prueba food.xlsx

JosephSerpis

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.