Discussion Board for collaboration on QlikView Scripting.
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.
Go to Solution.
This is the script,
let me know
LOAD * Inline [
Nbr, Pnbr, Sek, mSek
LOAD Nbr as Nbr1, Pnbr as Pnbr, Sek as Sek1, mSek as mSek1 Resident Tab1;
LOAD Nbr as Nbr2, Pnbr as Pnbr, Sek as Sek2, mSek as mSek2 Resident Tab2;
DROP Tables Tab1, Tab2;
If(Nbr2=1 or Nbr2=2, Sek2, Sek1) as Sek,
If(Nbr2=1 or Nbr2=2, mSek2, mSek1) as mSek,
1 as Nbr
DROP Table Tab_Tmp;
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?
Simply add the control on num3 in your if ....
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