Unwanted multiple rows

[bramvdpoel]

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?

[rubenmarin · Accepted solution]

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 ...

[bramvdpoel]

Worked perfectly! Thx