How to add the unique numbers to every row of the output?

Techy007
Techy007 Member
in Magic ETL

I have dataflow which consists of ETL o/p( table 1+Table 2) as i/p in sql.

and further this I need to send it to another department, so they can fill in the blank  fields. Thy will be able to fill in the blank fields only if I add the unique Key to each row of the o/p

1.I did add the Index of General type- looks like it did not work.- what  shall be my alternative ?

2. How will I export the o/p from dataflow ?

 

Thanks.

Comments

  • ST_-Superman-_
    ST_-Superman-_ Coach

    You mention both ETL and SQL in your question.  Are you wanting to add the unique row identifier in the magic ETL dataflow, or via the MySQL dataflow?


    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
  • Techy007
    Techy007 Member

    Either, I tried doing it in SQL. by ading Alter table- indexing . no luck!

     

    Please give me code to include Unique number to every row of the o/p in SQL or ETL

  • GrantSmith
    GrantSmith Coach

    You can utilize the Rank & Window widget in a Magic ETL dataflow. Just select the row number function from the list and specify which column to order by.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Categories