Conflicting field that actually isn't

Question

Hello

I have a flow that i have been using for many months. Today, out of nowhere i got the below error and I haven't been able to resolve it. The join tool seems to think something has been renamed the same as another field. For some reason the join tool is duplicating the lines (see second screen shot). I cannot simply tick one of them...the only way i can continue to push the data past this point is to remove that field entirely.

Please help

danilang · Answer

Hi @pangersandmash

Try right-clicking on the Options and selecting Forget all Missing Fields.

Dan

pangersandmash · Answer

File layout definitely hasn't changed. These fields are showing in the tool before - see above.

Could it be something to do with 'description' saying 'texttocolumns'. These are the fields affected...however that doesn't explain why the field 'revenue product' is coming up with an error

binu_acs · Answer

@pangersandmash for me it is look like  data issue. Can you please check your input file and make sure the file layout did not change?