Skip to content

    • Magic ETL

    Magic ETL

    indexing on domo

    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

    • 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! ✔️**

    • 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: Site faviconCustomer Support Community

      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

    • 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! ✔️**

    • 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: Site faviconCustomer Support Community

      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

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories