Removing Row Errors in Tables from a Merged Query

[Anonymous]

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]

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

[Anonymous · Accepted solution]

I found what I was looking for: