Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
解決済み

Dynamic Input tool error

praneshsapmm
アステロイド

Hello ,

 

Can someone help me with this . 

 

I trying to upload two file from directory using dynamic input . But only the first file passes through not the other one . Any clue .

 

For set up i did please refer the workflow attached .

 

Many thanks .
14件の返信14
Emil_Kos
17 - Castor
17 - Castor

Hi @praneshsapmm,

 

Can you chek if both files have the same sheet name?

 

Emil_Kos_0-1605534111032.png

 

praneshsapmm
アステロイド

Hi, Thanks for reply . Yes i checked . Both have sheet1 and same schema .

 

 

Emil_Kos
17 - Castor
17 - Castor

Hi @praneshsapmm,

 

do you see those two files in the data?

 

Emil_Kos_0-1605534412964.png

I am asking that because I want to check at which stage you have a problem. Do you see those files in the directory tool? 

praneshsapmm
アステロイド

Hi @Emil_Kos 

 

Yes i can in formula tool under fullpath , both the files with 'Sheet1$' .

 

Thanks

messi007
15 - Aurora
15 - Aurora

Dear @praneshsapmm 

Please see the attached workflow

 

messi007_0-1605534526323.png

messi007_1-1605534555341.png

 

Attached the workflow,

 

Regards

praneshsapmm
アステロイド

Hi @messi007 

 

 

This is already in place.But still the error.

Emil_Kos
17 - Castor
17 - Castor

Hi,

 

In my opinion, those sheets aren't exactly the same.

 

Use the Info tool and then join in each spreadsheet's info tool resulting in metadata to compare data types, lengths, etc.
 
It should allow you to identify where is the issue. 
 
 

Pick.png

 
 
 
 

 

 

 

 
 
 

 

 

praneshsapmm
アステロイド

Hi@Emil_Kos ,

 

Correct . One field datatype is differing . Also one file had 3 additional fields . 

 

Which one could be causing the issue and how to fix .

 

Thanks. 

messi007
15 - Aurora
15 - Aurora

Dear @praneshsapmm,

 

Could you share a sample of your inputs please.

 

Regards,

ラベル
トップのソリューション投稿者