Forum Discussion

dirkhiggler's avatar
dirkhiggler
New Member
8 years ago
Solved

Cannot convert value "0" to type table

Hi all,   I've searched high and low but haven't been able to find a solution to my exact problem, which is similar to a number of other posts, but not the same from what I can see.   I'm pulling...
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    dirkhiggler,

     

    You may try to change it as follows.

        #"Expanded defect_2" = Table.ExpandListColumn(Table.ReplaceValue(#"Expanded additional_photos_if_required.record"
                                                                    , each [defect_2]
                                                                    , each if Value.Is([defect_2], type list) then [defect_2] else {}
                                                                    , Replacer.ReplaceValue
                                                                    , {"defect_2"})
                                                , "defect_2")
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

dirkhiggler,

 

You may try to change it as follows.

    #"Expanded defect_2" = Table.ExpandListColumn(Table.ReplaceValue(#"Expanded additional_photos_if_required.record"
                                                                    , each [defect_2]
                                                                    , each if Value.Is([defect_2], type list) then [defect_2] else {}
                                                                    , Replacer.ReplaceValue
                                                                    , {"defect_2"})
                                                , "defect_2")
dirkhiggler's avatar
dirkhiggler
New Member
8 years ago

Hi v-chuncz-msft,

 

Thanks very much for your help, that has solved the problem very elegantly.

 

Regards,
Iain