Forum Discussion

Revathi_Kannan's avatar
Revathi_Kannan
Icon for Helper I rankHelper I
3 years ago
Solved

Columns reflected with Error

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.  
Need Help
  • BA_Pete's avatar
    BA_Pete
    3 years ago

    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

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
3 years ago

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's avatar
Revathi_Kannan
Icon for Helper I rankHelper I
3 years ago

Hi Ba_pete,

 

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

  • BA_Pete's avatar
    BA_Pete
    Icon for Super User rankSuper User
    3 years ago

     

    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's avatar
      Revathi_Kannan
      Icon for Helper I rankHelper I
      3 years ago

      Hi Ba_pete,

       

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

      • BA_Pete's avatar
        BA_Pete
        Icon for Super User rankSuper User
        3 years ago

         

        No problem, happy to help.

         

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

         

        Pete