Forum Discussion
Solved
How to Join Two Columns Into One Based on Data Values
I have a dilemma in my Tables and Columns. We manage preventative work in an application and I'm working with that data. I notice that when the preventative work is tied to an "Asset", the "Location"...
In the Query Editor you can simply choose Merge Columns on the Transform tab.
I cannot click on that option; is there a step prior to that?
Watch this video.
Thanks; saw the video but cannot select both columns, they are in different tables and when I try and use Shift and/or Control with a Click Select, one of the selections defaults to the first column of the last table, so it merges a different column and not the one I want. Is there another way to select them?
What it the relationship between both tables (Asset and Preventative Maintenance)
I think you can use Related Function.