topic Re: Looping with Concatenation in QlikView

Looping with Concatenation

Wed, 19 Nov 2014 06:22:20 GMT

Hi All,

How the looping is done with concatenation.

As of now I am loading data as

Actual:

Load

Month1,

Year1,

KeyData

Resident Temp;

Conatenate

Load

Month2,

Year2,

KeyData

Resident Temp;

Conatenate

Load

Month3,

Year3,

KeyData

Resident Temp;

Conatenate

Load

Month4,

Year4,

KeyData

Resident Temp;

Can we write a Loop statement so that it loops for 4 times with concatenating the data so that my code size decreases?

Re: Looping with Concatenation

anbu1984 — Wed, 19 Nov 2014 06:34:46 GMT

Temp:

LOad * Inline [

KeyData,Month1,Year1,Month2,Year2

1,Jan,2011,Feb,2012

2,Jan,2011,Feb,2012 ];

For I = 1 to 2

Temp1:

Load

Month$(I) As Month,

Year$(I) As Year,

KeyData

Resident Temp;

Re: Looping with Concatenation

Wed, 19 Nov 2014 06:38:12 GMT

HI ,

What about concatenation?

Re: Looping with Concatenation

anbu1984 — Wed, 19 Nov 2014 06:39:29 GMT

If you have same field names, concatenation happens automatically

Re: Looping with Concatenation

sujeetsingh — Wed, 19 Nov 2014 06:42:42 GMT

Temp:

LOad * Inline [

KeyData,Month1,Year1,Month2,Year2

1,Jan,2011,Feb,2012

2,Jan,2011,Feb,2012 ];

For I = 1 to 2

Concatenate

Load

Month$(I) As Month,

Year$(I) As Year,

KeyData

Resident Temp;

Re: Looping with Concatenation

Wed, 19 Nov 2014 06:57:35 GMT

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.

Like below:

Load

Month1 As Month,

Year1 As Year,

KeyData,

X+y = Z

Resident Temp;

Concatenate

For I = 2 to 3

Load

Month$(I) As Month,

Year$(I) As Year,

KeyData

Resident Temp;

Re: Looping with Concatenation

anbu1984 — Wed, 19 Nov 2014 07:04:06 GMT

Temp1:

Load

Month1 As Month,

Year1 As Year,

KeyData,

X+Y As Z

Resident Temp;

For I = 2 to 3

Concatenate

Load

Month$(I) As Month,

Year$(I) As Year,

KeyData

Resident Temp;

Re: Looping with Concatenation

Wed, 19 Nov 2014 07:29:11 GMT

Am I doing some mistake?

I should Get only one table But

I am getting two tables with a SynTable.

Temp:

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

Main:

Load

Key,

Week$(i) as Week,

Act$(i) as Act,

For$(i) as For,

Zero

Resident Temp;

ENDIF

if ($(i)>1) then

Concatenate

Main:

Load Key,

Week$(i) as Week,

Act$(i) as Act,

For$(i) as For

Resident Temp;

Drop Table Temp;

Re: Looping with Concatenation

anbu1984 — Wed, 19 Nov 2014 07:33:41 GMT

You missed ENDIF for second If statement

Temp:

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

Main:

Load

Key,

Week$(i) as Week,

Act$(i) as Act,

For$(i) as For,

Zero

Resident Temp;

ENDIF

if ($(i)>1) then

Concatenate

Main:

Load Key,

Week$(i) as Week,

Act$(i) as Act,

For$(i) as For

Resident Temp;

ENDIF

Drop Table Temp;