topic Re: Pick up latest else pick up second level data in QlikView

Pick up latest else pick up second level data

Tue, 17 Jan 2012 09:53:12 GMT

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.

Re: Pick up latest else pick up second level data

lironbaram — Tue, 17 Jan 2012 10:50:55 GMT

hei

try this one

i think it what you want

Re: Pick up latest else pick up second level data

Tue, 17 Jan 2012 11:40:47 GMT

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