Kingswaysoft record update: Is there a way to add a variable that increases eacht time with +1

Question

What I have is productname: playstation productname: xbox

What I want is: productname: product 1 productname: product 2

I'm using a derrived column to achieve this but can't find a way to add a variable that increases each time with +1

Is there a way to concatenate a string "product" with the row number for example?

Daniel Cai · Answer 1 · 2020-03-27T14:22:45.113

0

If you use our Premium Derived Column component, you could easily achieve this using the RowIndex() function that we offer. Premium Derived Column component is part of our SSIS Productivity Pack offering.

edited Mar 27 '20 at 14:22

answered Mar 27 '20 at 12:57

Daniel Cai

446
2
7

Kingswaysoft record update: Is there a way to add a variable that increases eacht time with +1

1 Answers1