I have a project that will concantenate a few columns to form a url, I need a unique value for each row. Currently I'm using the modify column task, but I can't figure out how to create a counter for the unique value.
column 1 column 2 column 3 column 4
www .testing.com/ 0001 www.testing.com/0001
www .testing.com/ 0002 www.testing.com/0002
www .testing.com/ 0003 www.testing.com/0003
www .testing.com/ 0004 www.testing.com/0004
www .testing.com/ 0005 www.testing.com/0005
Column's 1 and 2 are in the file already, I need to create column 3 which increments by 1, then concat all in column 4. I can do everything but create column 3, I'm not sure how to do that without a loop.