topic Re: mapping table has two values in QlikView

mapping table has two values

manoranjan_d — Mon, 13 Aug 2018 14:38:04 GMT

Hi while doing mapping load suppose if the table T1 has two values for the specific field "A" wht will happen while doing doing apply map on T2 and how we can avoid this duplicates and wht is solution for this scenario

T1:

A	B
1	A
1	B
2	C
3	D
3	E
4	F

T2:

A	C
1	A
2	C
3	D
4	F

MAP:

MAPPING LOAD

FROM

(ooxml, embedded labels, table is Sheet1);

T2:

LOAD A,

ApplyMap('MAP',A) as B

FROM

(ooxml, embedded labels, table is Sheet1);

i got an output as:

A	B	C
1	A	A
2	C	C
3	D	D
4	F	F

since it taking the first value if it being duplicate

Re: mapping table has two values

olivierrobin — Mon, 13 Aug 2018 15:02:02 GMT

hello

as applymap() returns ONE value, the question is : which one do you want to retrieve ?

and so add some logic in the mapping load to load only one row

Re: mapping table has two values

manoranjan_d — Mon, 13 Aug 2018 15:04:45 GMT

can you please explain the logic to load only one row

Re: mapping table has two values

olivierrobin — Mon, 13 Aug 2018 15:08:11 GMT

mapping load A,maxstring(B) as B

group by A

or any function you want returning only a single value

Re: mapping table has two values

tamilarasu — Mon, 13 Aug 2018 15:39:11 GMT

Or try,

MAP:

MAPPING LOAD

FROM

(ooxml, embedded labels, table is Sheet1) where Not Exists (A);