Create groups based on values from two columns.

[simrankalda]

Hi, 

I have requirement in which I need to create a new column based on the different combination of values from some other columns.  

For example Column Product contains - A,B,C fields and Column category contains - D,E,F. The new column is created as :

 Combination || New column values         

A & D              - 1

B & E               - 2

C & F              - 3 

Thanks in advance

[simrankalda]

Hi Amit, Thanks for the response

These two columns are present in different tables.

[amitchandak]

@simrankalda , what is logic

You have append

[Product] & [Category]

You can have rank

rankx(Table, [Combined column],,asc,dense)