Assign values to the newly created calculated column based on the comparison in the column

[deep2021]

Hi All,

I have a scenario as per the below,

Col3 is a calculated column.
For all similar values in Col4, in the calculated column Col3, I need to insert the first value in Col2.

For instance, for all 1 in Col4, in the calculated column Col3,there should be 2003Q4 which is the first value in Col2.

Could you please suggest on this.

thanks

[avinashelite]

Try like this 

Colum_Map:

Mapping

LOAD

Distinct

Rowno() as Key

Col2

from table;

LOAD 

Col1,

Col2,

Appplymap('Colum_Map',Col4) as Col3,

Col4

from table;