Forum Discussion

Revathi_Kannan's avatar
Revathi_Kannan
Helper 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
    Super 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

      • BA_Pete's avatar
        BA_Pete
        Super 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