Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Issue loading tables.

The issue is explained in the PDF which is attached.

Any help is greatly appreciated, unsure of how to reach

the target without using some form of delete-statement.

1 Solution

Accepted Solutions

Re: Issue loading tables.

This is the script,

let me know

Tab1:

LOAD * Inline [

Nbr, Pnbr, Sek, mSek

1,1991,611,1

1,1992,612,1

];

Tab2:

NoConcatenate

LOAD * Inline [

Nbr, Pnbr, Sek, mSek

2,1991,612,0

1,1993,612,1

];

Tab_Tmp:

NoConcatenate

LOAD Nbr as Nbr1, Pnbr as Pnbr, Sek as Sek1, mSek as mSek1 Resident Tab1;

Join

LOAD Nbr as Nbr2, Pnbr as Pnbr, Sek as Sek2, mSek as mSek2 Resident Tab2;

DROP Tables Tab1, Tab2;

Tab_Final:

NoConcatenate

LOAD

  Pnbr,

  If(Nbr2=1 or Nbr2=2, Sek2, Sek1)   as Sek,

  If(Nbr2=1 or Nbr2=2, mSek2, mSek1) as mSek,

  1 as Nbr

Resident Tab_Tmp;

DROP Table Tab_Tmp;

4 Replies

Re: Issue loading tables.

This is the script,

let me know

Tab1:

LOAD * Inline [

Nbr, Pnbr, Sek, mSek

1,1991,611,1

1,1992,612,1

];

Tab2:

NoConcatenate

LOAD * Inline [

Nbr, Pnbr, Sek, mSek

2,1991,612,0

1,1993,612,1

];

Tab_Tmp:

NoConcatenate

LOAD Nbr as Nbr1, Pnbr as Pnbr, Sek as Sek1, mSek as mSek1 Resident Tab1;

Join

LOAD Nbr as Nbr2, Pnbr as Pnbr, Sek as Sek2, mSek as mSek2 Resident Tab2;

DROP Tables Tab1, Tab2;

Tab_Final:

NoConcatenate

LOAD

  Pnbr,

  If(Nbr2=1 or Nbr2=2, Sek2, Sek1)   as Sek,

  If(Nbr2=1 or Nbr2=2, mSek2, mSek1) as mSek,

  1 as Nbr

Resident Tab_Tmp;

DROP Table Tab_Tmp;

Not applicable

Re: Issue loading tables.

I'm rather new at this point.

If there was a possibility of the table containing

number 3 which would imply that rows in table1

would have to be removed, how would you approach the problem?

Re: Issue loading tables.

Simply add the control on num3 in your if ....

Not applicable

Re: Issue loading tables.

I've been trying but I don't really know the syntax for the exclusion part

in the If-statement. I've attached an updated PDF if there is anyone

whom perhaps have an idea

Community Browser