Forum Discussion
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 in the Table. Is there simple way to go over it and make both values visible in new added column?
Thank You
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] )
5 Replies
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.
Yes, i m not using coding very often. I changed as you writed and now I have new error with Column name:
I found my mistake and now its worked. Thank you very much!!
