Anyone else wanting to join to the same table multiple times in a view?

WHM

I have a dataset with regional director id, regional vp id and senior vp id and I want to join to my employee master on each of them but you can only bring the table in once. it would be really convenient to be able to use a view rather than a dataflow.

ColemenWilson

Figured it out, but you'll have to use the Advanced SQL Editor in dataset views. Once a dataset view is converted to an Advanced SQL dataset view it cannot be reverted back. https://domo-support.domo.com/s/article/360046074774?language=en_US#advanced_sql_editor

ColemenWilson

You could make duplicate views and bring those in as additional datasets to join twice more.

WHM

@ColemenWilson That is an interesting thought… but I need to join it back 9 times…. SAP Vistex tables are really a pain.

ColemenWilson

Figured it out, but you'll have to use the Advanced SQL Editor in dataset views. Once a dataset view is converted to an Advanced SQL dataset view it cannot be reverted back. https://domo-support.domo.com/s/article/360046074774?language=en_US#advanced_sql_editor