Joining on table multiple times

ABauman

We are working on building out our backend in DOMO and are trying to build a relational database instead of having individual queries for everything. We are connected to NetSuite through Analytics Connect.

The raw table we are bringing in has columns for employee, service tech, service manager, etc. In NetSuite, these all reference the employee table. In DOMO I have brought in a raw transactional data set that has columns for each of the above fields that are bringing in the internal ID, I have also brought in a raw employee table that has the internal ID and the name info, essentially we need to join back on the employee table for each of those columns to bring in the name instead of the internal id for each.

From what I can see magic ETL won't let you bring in a dataset more than once so I am stumped on how to accomplish this, I would appreciate any help on this.

I'm hoping it is just a lack of experience in DOMO and not a lacking feature.

ColemenWilson

You can use the input multiple times, just drag lines from the input to additional tiles.

You could then join the data as needed.