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

[Brice-SACCUCCI · Accepted solution]

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

[its_anandrjs]

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

[prieper]

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

[its_anandrjs]

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.

[its_anandrjs]

Can you check your script also.

[Anonymous]

This works! Thanks a lot!!

[Anonymous]

This works! Thanks a lot!!

[Anonymous]

This works! Thanks a lot!!

[Anonymous]

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