Issue loading tables.

[#1]

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.

[alexandros17 · Accepted solution]

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;

[#3]

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?

[alexandros17]

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

[#5]

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