Is there a way to merge a relationship column with lookup?

I have two columns - one that is a relationship column and another one there a lookup of relationship column.

Is it possible to merge them into another column?

You can merge your columns into a group by adding " GroupName/ " in front of the headers of your columns in the data editor.

For example:

Plates/Tracking Lines
Plates/TrackingLineKilnUnload

When you click on “Plates” which will be above the column headers, you’ll be able to collapse and uncollapse the group.

(taking your question to mean something else that Nathaneal answered)

Short answer: No.

Longer Answer: Let’s pretend for a moment that it is possible. What would you expect the result to look like, and what would you do with it?

Probably what you could do is create another Lookup column that operates on your multiple relation. This would give you two lookup columns, both containing an array of values. And you could combine those using a MakeArray column.

I basically just want it to be a full list to easier do rollups and summarise things - but I can think of a few ways around it. It was just if it was possible as it would save me some columns.

1 Like

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