Forum Discussion
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 ...
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] )
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?
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.