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

[Anonymous]

Hi

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

[its_anandrjs]

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);