Forum Discussion

FJS's avatar
FJS
Regular Visitor
2 years ago
Solved

Grouping Column

Hi, It might be a stupid question. I tried but not able to find the perfect result.   I am trying to convert multiple columns into group rows in power query.   Below are the examples.   Data w...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi FJS 

    This error indicates that you are trying to convert a text type value into Number type. This usually happens in the Changed type step. Please check whether the value "FC0001" appears in "PCI" column. If so, change its column type to text instead. 

     

    Change below step from

     

    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"PCI", Int64.Type}, {"PCI Name", type text}, {"PCI Name_1", type text}, {"SiteIn", type text}, {"SiteIn_2", type text}}),

     

    to

     

    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"PCI", type text}, {"PCI Name", type text}, {"PCI Name_1", type text}, {"SiteIn", type text}, {"SiteIn_2", type text}}),

FJS's avatar
FJS
Regular Visitor
2 years ago

Attaching snippet for more clarity.