Discussion Board for collaboration on QlikView Scripting.
How the looping is done with concatenation.
As of now I am loading data as
Can we write a Loop statement so that it loops for 4 times with concatenating the data so that my code size decreases?
Go to Solution.
You missed ENDIF for second If statement
LOAD * INLINE [
Key, Week1, Week2,Week3, Act1, Act2, Act3, For1, For2, For3, Zero
ABC, 1, 2, 3, 20, 30, 40, 20, 30, 40, Y
BCD, 1, 2, 3, 20, 30, 40, 15, 30, 100
DEF, 1, 2, 3, 20, 30, 40, 25, 50, 200
For i = 1 to 3
if ($(i)=1) then
Week$(i) as Week,
Act$(i) as Act,
For$(i) as For,
if ($(i)>1) then
For$(i) as For
Drop Table Temp;
LOad * Inline [
For I = 1 to 2
Month$(I) As Month,
Year$(I) As Year,
What about concatenation?
If you have same field names, concatenation happens automatically
What If i want to load
Key, Month1, Year1 seperately and then Concatenate the Looping Table.?
Because While loading Key, Month1, Year1 I will load one more calculated field and that field will not have value to other rows.
Month1 As Month,
Year1 As Year,
X+y = Z
For I = 2 to 3
X+Y As Z
Am I doing some mistake?
I should Get only one table But
I am getting two tables with a SynTable.