Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;