Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
hei
try this one
i think it what you want
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