Pick up latest else pick up second level data

[#1]

Dear All,

Here is the attached excel file and output in other sheet, i got the solution in some manner but i feel that is not right method and anyone let us know the better script.

Regards

Ravi.

[lironbaram]

hei

try this one

i think it what you want

[#3]

Hi, Thanks for your reply, But as compared to ur solution mine is little bit better.

Load

MinString(ID&TYPE) As KEY,
MinString(ID&TYPE) As KEY1
FROM
[..\..\..\..\\Test.xlsx]
(ooxml, embedded labels, table is Sheet1) Where TYPE ='1' OR TYPE ='2' Group By ID;

Inner Join

Load
ID&TYPE As KEY1,
ID,
TYPE,
SALARY
FROM
[..\..\..\..\\Test.xlsx]
(ooxml, embedded labels, table is Sheet1) ;

Regards,Ravi