Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

What is wrong with this script?

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;

3 Replies
Not applicable
Author

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.

Not applicable
Author

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

sasikanth
Master
Master

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....