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

5 Replies

  • 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