topic Re: Unwanted multiple rows in QlikView

Unwanted multiple rows

bramvdpoel — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I'm load from multiple .txt tables.

Table A :

[Deltakey]
[Article]
[Descr]

Table B :

[Deltakey]
[TBSNr]

Table C:

[TBSNr]
[ArtInfo]
[RowNr]

Made the expression for Table C:

IF([RowNr=001, [ArtInfo]) as [Artinfo1]

IF(RowNr=002, [ArtInfo]) as [ Artinfo2]

Table gets loaded:

Row1: [Deltakey][Article][Artinfo1][Blank]

Row2: [Deltakey][Article][Blank][Artinfo2]

How do i get artinfo1 & artinfo2 in the same row?

Re: Unwanted multiple rows

rubenmarin — Thu, 28 Mar 2019 17:54:46 GMT

Hi, each TBSNr has 2 rows?
You can start loading Table C to do the mappings:
mapArtinfo1:
Mapping LOAD TBSNr, ArtInfo From ... Where RowNr=1;

mapArtinfo2:
Mapping LOAD TBSNr, ArtInfo From ... Where RowNr=2;

And load Table B as:
LOAD DeltaKey, TBSNr,
ApplyMap('mapArtinfo1', TBSNr, Null()) as Artinfo1,
ApplyMap('mapArtinfo2', TBSNr, Null()) as Artinfo2,
From ...

Re: Unwanted multiple rows

bramvdpoel — Fri, 29 Mar 2019 15:53:39 GMT

Worked perfectly! Thx