Columns reflected with Error

[Revathi_Kannan]

Hi Team,

I have a column wherein it is mixed of Numerical, string and Alphanumerical but string and Alphanumerical reflected with errors. Please assist me to resolve this.

[BA_Pete · Accepted solution]

Hi @Revathi_Kannan ,

I suspect that Power Query has auto-detected your column types and has converted this column to number type.

Select the 'Changed Type' step after the 'Promoted Headers' step then change your [Tax2] column type to Text. Choose to replace the existing step, rather than creating a new one.

Pete

[Revathi_Kannan]

Hi Ba_pete,

Thanks for your reply. But still i am getting an error.

[BA_Pete]

Ok, but that's not on the table you've posted about. You posted about AgencyResponse_xl, which now appears to be working.

Pete

[Revathi_Kannan]

Hi Ba_pete,

Sorry for the confusion. It is working fine now. Thanks a lot.

[BA_Pete]

No problem, happy to help.

Don't forget to give a thumbs-up on any posts that have helped you 👍

Pete