indexing on domo

mroker

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.

david_cunningham

@mroker

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

ColemenWilson

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

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

david_cunningham

@mroker

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

ColemenWilson

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

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