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

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

Administrator

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

Super 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.

Forum Discussion

Power Querry value stored as Table