Forum Discussion

ykannan's avatar
ykannan
Helper I
4 years ago
Solved

How to expand list column which has empty data

Hi Friends, I am taking data from Firebase DB which has List columns. One of the column data.caxxxx_order_id has empty data and more than one data.    Below is the code where I need to change to d...
Need Help
  • ykannan's avatar
    ykannan
    4 years ago

    I found a simple solution for this . This will save others friend's lot of time. If Microsoft added this step as part of ExpandListColumn, would be great.

     

    Solution:

    //Just replace the empty value to empty list as below, that is it.

    #"Replaced Value" = Table.ReplaceValue(#"Removed Other Columns","",{""},Replacer.ReplaceValue,{"order_id"}),

    //Then expand the column and refresh without that error.
    #"Expanded" = Table.ExpandListColumn(#"Replaced Value", "order_id")

     

ykannan's avatar
ykannan
Helper I
4 years ago

I found a simple solution for this . This will save others friend's lot of time. If Microsoft added this step as part of ExpandListColumn, would be great.

 

Solution:

//Just replace the empty value to empty list as below, that is it.

#"Replaced Value" = Table.ReplaceValue(#"Removed Other Columns","",{""},Replacer.ReplaceValue,{"order_id"}),

//Then expand the column and refresh without that error.
#"Expanded" = Table.ExpandListColumn(#"Replaced Value", "order_id")

 

fricketyfrack's avatar
fricketyfrack
Regular Visitor
2 years ago

Genius!