How to select distinct in workbench

I have a column with Firm and FirmId. Each Firm has multiple FirmId's. I want to select distinct Firms.

How can i select distinct Firms regardless of FirmId.

And how can I select distrinct Firms based on minimum FirmId?

Best Answer

  • zcameron
    zcameron admin
    Answer ✓

    Doing this in Workbench would depend on what type of data it is. Is it an ODBC connection, Excel spreadsheet, etc.?


    You could do this in Magic ETL after the data is in Domo. To do this, you could use the Select Columns transform to grab only the Firm column, then use a Remove Duplicates transform to narrow it down to unique values.


    Let me know how that goes for you.


  • @32, did zcameron's reply help you out?

  • I was able to fix my query in workbench and your help with ETL worked as well, thank you.

This discussion has been closed.