Dataview aggregate different keys to show as one column

What I’m trying to do

I used one key in some file to store value of an id, and then another key in some files. I want to aggregate one in one column in the table of dataview.

Things I have tried

TABLE  (row["key A"] or row["key B"]) AS "ID"

not working…

Does the following work:

TABLE  default(row["key A"], row["key B"]) AS "ID"

It should select the first value, and if that’s not present the second one. It depends a little on the presence and definition of your values though.

1 Like

Thanks so much! That works!

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.