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 .

[Emil_Kos]

Hi @praneshsapmm,

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

[praneshsapmm]

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

[Emil_Kos]

Hi @praneshsapmm,

do you see those two files in the data?

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]

Dear @praneshsapmm 

Please see the attached workflow

Attached the workflow,

Regards

[praneshsapmm]

Hi @messi007 

This is already in place.But still the error.

[Emil_Kos]

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. 

 

[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]

Dear @praneshsapmm,

Could you share a sample of your inputs please.

Regards,