topic What is wrong with this script? in QlikView

What is wrong with this script?

Fri, 25 Oct 2013 06:55:04 GMT

hello friends,

I am using this script to concatenate two table whose path is provided with the concatenate function as follow.

Concatenate (E:\Poornima\Company.xlsx) load * from E:\Poornima\CompanyPurchase.xlsx ;

It is giving me error table not found.

please tell me my mistake.

Thanks in advance;

Re: What is wrong with this script?

Fri, 25 Oct 2013 07:14:30 GMT

Hi Nupur,

Load the Company.xlsx data first, then concatenate the data from CompanyPurchase.

Use also the wizard when loading data from excel for complete syntax.

Company:

Load *

from ....

Concatenate(Company)

Load *

from ...

On another hand, be sure that your really want to concatenate those two tables.

If the Company xls represents info about companies (id, description, etc...), you'll use it as dimension to be linked to the Purchases.

But that's just a hint

Anyways hope this helps.

Re: What is wrong with this script?

Fri, 25 Oct 2013 07:16:35 GMT

You need to load E:\Poornima\Company.xlsx first, e.g.

Company:

LOAD * from

[E:\Poornima\Company.xlsx]

(ooxml, embedded labels, table is Sheet1);

Concatenate (Company)

LOAD * from

[E:\Poornima\CompanyPurchase.xlsx]

(ooxml, embedded labels, table is Sheet1);

Make sure concatenate is what you actually want to do. Or do you want to join (associate) the two tables? Please provide the field names in both tables if that is the case

Re: What is wrong with this script?

sasikanth — Fri, 25 Oct 2013 07:21:15 GMT

Hi Nupur ...

First load the Company table first and then give an alias name to it (better)...

CPNY:

Load *

...

From

E:\Poornima\Company.xlsx;

concatenate(CPNY)

load *

from .....

hope it will work....