indexing on domo

mroker
mroker Member
in Magic ETL

Is there a way if i have a dataset to simply create a unique id? For example, if I have a dataset of 10 rows and I want to label the row ID, and start at 1, then 2, etc.

Tagged:

Best Answers

  • david_cunningham
    david_cunningham Coach
    edited June 2024 Answer ✓

    @mroker

    Sure - just use the row number function within the Rank & Window tile in MagicETL to create a consecutive unique id.

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**

  • ColemenWilson
    ColemenWilson Coach
    Answer ✓

    Yes, you can use the rank and window tile in Magic ETL:

    Screenshot 2024-06-06 at 9.15.11 PM.png

    Here is KB article with more info: https://domo-support.domo.com/s/article/360042922814?language=en_US go down to the "Row Number" section.

    If you want a bit more in an ID value, you could take the row number and combine it something using a formula tile, for example: CASE WHEN `Department` = 'Sales' THEN CONCAT('S - ',`ID`) ELSE `ID` END

    If I solved your problem, please select "yes" above

Answers

  • david_cunningham
    david_cunningham Coach
    edited June 2024 Answer ✓

    @mroker

    Sure - just use the row number function within the Rank & Window tile in MagicETL to create a consecutive unique id.

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**

  • ColemenWilson
    ColemenWilson Coach
    Answer ✓

    Yes, you can use the rank and window tile in Magic ETL:

    Screenshot 2024-06-06 at 9.15.11 PM.png

    Here is KB article with more info: https://domo-support.domo.com/s/article/360042922814?language=en_US go down to the "Row Number" section.

    If you want a bit more in an ID value, you could take the row number and combine it something using a formula tile, for example: CASE WHEN `Department` = 'Sales' THEN CONCAT('S - ',`ID`) ELSE `ID` END

    If I solved your problem, please select "yes" above

Categories