topic concatenate in QlikView

concatenate

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have two tables in the data base

table1 and table2

table1 having total weeks data and table2 has only this week data [All columns are same ]

so now am doing the concatenation like below is it correct or wrong?

Table1:

load id,

WeekNumber,

----

FROM .dbo."Master.table1"

where WeekNumber>=$(vMaxWeek);

concatenate(tabl1)

Table2:

load id,

WeekNumber

---

FROM .dbo."Master.table2";

Store Table1 into [lib://QVD_DATA/MainTable.qvd];

Drop Table Table1;

Re: concatenate

Anil_Babu_Samineni — Thu, 14 Sep 2017 09:47:04 GMT

Correct one only, Can you explain how you declare the vMaxWeek and which table field you used?

Re: concatenate

soniasweety — Thu, 14 Sep 2017 09:49:00 GMT

variable is below

and field used is table1

let vMaxWeek= Num(Peek('MaxWeek',0,'MaxWeek'))-1;

Re: concatenate

Anil_Babu_Samineni — Thu, 14 Sep 2017 09:51:28 GMT

Yes approach is correct one only

Re: concatenate

its_anandrjs — Thu, 14 Sep 2017 11:28:32 GMT

Try this in where one of this check which is worked for you

where WeekNumber >= $(vMaxWeek);

where WeekNumber >= '$(vMaxWeek)';

Table1:

load id,

WeekNumber,

----

FROM .dbo."Master.table1"

where WeekNumber >= $(vMaxWeek);

//Here you use wrong table name concatenation you use Concatenate(tabl1) which is wrong.

concatenate(Table1)

Table2:

load id,

WeekNumber

---

FROM .dbo."Master.table2";

Store Table1 into [lib://QVD_DATA/MainTable.qvd];

Drop Table Table1;