MAPPING WITH FUNCTIONS

[#1]

Hi can anyone pls suggest whether the below mentioned script is possible in qlikview also suggest me if there is any alternative for the same

MAP:

Mapping

LOAD PLANT,

     MAX(Amount)

FROM

C:\Users\Admin\Desktop\Book1.xlsx

(ooxml, embedded labels, table is Sheet1);

Thanking You

Vinayagam

[#2 · Accepted solution]

Hi,

It is not possible without using group by function as under:

MAP:

Mapping

LOAD PLANT,

     MAX(Amount) as Amount

FROM

C:\Users\Admin\Desktop\Book1.xlsx

(ooxml, embedded labels, table is Sheet1)

group by PLANT;

[Colin-Albert]

You need to add a group by clause.

MAP:

Mapping

LOAD PLANT,

     MAX(Amount)

FROM

C:\Users\Admin\Desktop\Book1.xlsx

(ooxml, embedded labels, table is Sheet1)

Group by PLANT ;

[SunilChauhan]

its need group by Plan in from

i mean your

load

mapping

Load PLANT,

Max(Amount) as MaxAmount

from above path

group by PLANT;

hope this helps

[#5]

Thanks Friends for the valuable response ... Thank You