Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago
Solved

Power Querry value stored as Table

Hello,   I'm really struggling with one column. I imported data through the API, and some rows have the value visible, while others can be seen as a Table. I know that the correct value is present ...
  • AlienSx's avatar
    AlienSx
    2 years ago

    Hello, @Ints. If table consists of single row and column the try this: 

    Table.AddColumn(
   Source, "new_column_name", 
   (x) => try Table.FirstValue(x[data_column_name]) otherwise x[data_column_name]
)
Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

Thanky you for your answer. Seems that it may work, but there is error when record wasnt found. There are some null values too. Need to add something more?

  • AlienSx's avatar
    AlienSx
    Icon for Super User rankSuper User
    2 years ago

    I don't see how you may get an error with this code other than you don't know how to correctly incorporate it into yours. Replace data_column_name with SHVc.rows.row.SerialNr. Replace Source with the name of your last step.