Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Removing Row Errors in Tables from a Merged Query

I have a column created from a merged query that contains a couple things inside of a table.

For some reason, some of the tables contain a row of errors:

I need a way to either delete these errors in every table, or better just expand the JsonTags value from just the first row in every table into a new column. 

 

I am unsure why the errors are showing up in the first place since the merge should have matched based on the Date and ResourceId. If there was an error value, then it would not have matched. There were no errors in either sources though.

  • Anonymous's avatar
    Anonymous
    4 years ago

    I found what I was looking for:

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    I found what I was looking for:

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

    Is there anything else you need help with regarding this post? If not, could you please mark your post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours.  Thank you.

    Best Regards