Help me to derive a new field.

[durgabhavani]

Hi All,

Please help me to derive the new field (Rating occured) based on ID, Initial Rating, Latest Rating...

ID	Initial Rating	Latest Rating	Rating Occurred (New Field)
101	Low	Medium	Y
102	High	Low	Y
103		Low	Y
104	Medium		N
105	High	High	N
106			N

Thanks in advance.

Durga

[Anonymous · Accepted solution]

Like this ??

Load *,if(Len([Latest Rating])=0 or [Latest Rating]=[Initial Rating],'N','Y') as 'Rating Occurred' Inline [

ID,Initial Rating,Latest Rating

101,Low,Medium

102,High,Low

103,,Low

104,Medium

105,High,High

106

];

[vinieme12]

Do you think we also need to specify the evaluation condition of the new field?  Or did the Y and N populate randomly!!

[durgabhavani]

We need to evaluate the new field based on other two fields ( initail rating and latest rating).

shiva - I am trying your solution. Will let you know the result.

[Anil_Babu_Samineni]

What is logic behind to implement this?

[durgabhavani]

Just we need to derive one new field based on the two fields ( intial rating,latest rating). please find the above table for details.

Thank you shiva. it is working for me..

Durga...