topic Re: concatenate more than two data sets with a subset of identical variables into QV? in QlikView

concatenate more than two data sets with a subset of identical variables into QV?

Anonymous — Wed, 13 Sep 2017 12:08:49 GMT

I have a problem in QV when I load my data.

I have an application where I so far have loaded two data sets into QV. The two data sets have a number of variable names, which has the same name. The rest of the variable names are different.

So far this method hasn't got me into trouble.

But now I want to build a new tab in the application and load my new data set into QV. This new data set also have a number of variable names that are the same as in the other two data sets - and a lot of variables, that is not.

My problem is, that when I load the third data set into QV, some of my charts disappear/becomes empty.

I'm pretty sure that it is because of the identical variable names.

But I wonder how this wasn't a problem, when I loaded the second data set?

I have written that I can get QV to see all the data sets as one, if I use the concatenate function in the script.

I did that to combine data set1 with data set2, but when I try to load in the third data set (there will come 2 data sets more in time), QV reports an error.

How do I use the concatenate function to combine more than two data sets?

Now I do this:

data1:
LOAD *
FROM
[PATH\dataset1.xlsx]
(ooxml, embedded labels, table is Ark1);

concatenate(data1)

data2:
LOAD *
FROM
[PATH\dataset2.xlsx]
(ooxml, embedded labels, table is Ark1);

concatenate(data2)

data3:

LOAD *

FROM

[PATH\dataset3.xlsx]

(ooxml, embedded labels, table is Ark1);

Kind Regards

Maria

Re: concatenate more than two data sets with a subset of identical variables into QV?

Brice-SACCUCCI — Wed, 13 Sep 2017 12:13:20 GMT

Hello,

it's concatenate(data1) and not concatenate(data2) that you want to do

Check the model viewer after loading your data (CTRL + T).

Regards,

Brice

Re: concatenate more than two data sets with a subset of identical variables into QV?

its_anandrjs — Wed, 13 Sep 2017 12:13:52 GMT

In Concatenate(Tablename) you give wrong name try this

data1:
LOAD *
FROM
[PATH\dataset1.xlsx]
(ooxml, embedded labels, table is Ark1);

concatenate(data1)

data2:
LOAD *
FROM
[PATH\dataset2.xlsx]
(ooxml, embedded labels, table is Ark1);

concatenate(data1)

data3:

LOAD *

FROM

[PATH\dataset3.xlsx]

(ooxml, embedded labels, table is Ark1);

Re: concatenate more than two data sets with a subset of identical variables into QV?

prieper — Wed, 13 Sep 2017 12:14:55 GMT

should work as per below:

data1:
LOAD * 
  FROM
[PATH\dataset1.xlsx]
(ooxml, embedded labels, table is Ark1);

concatenate(data1)


LOAD *
FROM
[PATH\dataset2.xlsx]
(ooxml, embedded labels, table is Ark1);

concatenate(data1)


LOAD *   
FROM
[PATH\dataset3.xlsx]
(ooxml, embedded labels, table is Ark1);

Re: concatenate more than two data sets with a subset of identical variables into QV?

its_anandrjs — Wed, 13 Sep 2017 12:16:54 GMT

When you concatenate date3 you use key word concatenate(data2) but already the table data2 table concatenate to date1 and it is not available in data model so you have to use data1 as base name for all three or if you have more table then use same way.

If table has same fields then it is auto concatenate otherwise force concatenation.

data1:
LOAD *
FROM
[PATH\dataset1.xlsx]
(ooxml, embedded labels, table is Ark1);

concatenate(data1)

data2:
LOAD *
FROM
[PATH\dataset2.xlsx]
(ooxml, embedded labels, table is Ark1);

concatenate(data1)

data3:

LOAD *

FROM

[PATH\dataset3.xlsx]

(ooxml, embedded labels, table is Ark1);

Let me know about this.

Re: concatenate more than two data sets with a subset of identical variables into QV?

its_anandrjs — Wed, 13 Sep 2017 12:18:04 GMT

Can you check your script also.

Re: concatenate more than two data sets with a subset of identical variables into QV?

Anonymous — Wed, 13 Sep 2017 12:18:05 GMT

This works! Thanks a lot!!

Re: concatenate more than two data sets with a subset of identical variables into QV?

Anonymous — Wed, 13 Sep 2017 12:18:28 GMT

This works! Thanks a lot!!

Re: concatenate more than two data sets with a subset of identical variables into QV?

Anonymous — Wed, 13 Sep 2017 12:18:36 GMT

This works! Thanks a lot!!

Re: concatenate more than two data sets with a subset of identical variables into QV?

Anonymous — Wed, 13 Sep 2017 12:19:09 GMT

This works! Thanks a lot!! And now my table viewer is one big data set

Re: concatenate more than two data sets with a subset of identical variables into QV?

its_anandrjs — Wed, 13 Sep 2017 12:23:30 GMT

I believe you get error on the concatenate(data2) as table not found, did you get if not strange, also the Peter that suggest if you have same field names then use it like see correct code.

concatenate(data2)

data3:

LOAD *

FROM

[PATH\dataset3.xlsx]

(ooxml, embedded labels, table is Ark1);

Correct Load:-

Table1:
LOAD *
FROM
[PATH\dataset1.xlsx]
(ooxml, embedded labels, table is Ark1);

LOAD *
FROM
[PATH\dataset2.xlsx]
(ooxml, embedded labels, table is Ark1);

LOAD *

FROM

[PATH\dataset3.xlsx]

(ooxml, embedded labels, table is Ark1);