How to select distinct in workbench

Options
32
32 Member

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 Domo Employee
    Answer ✓
    Options

    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.

Answers

  • zcameron
    zcameron Domo Employee
    Answer ✓
    Options

    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.

  • kshah008
    kshah008 Contributor
    Options

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

  • 32
    32 Member
    Options

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

This discussion has been closed.