Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Not applicable

Re: What is wrong with this script?

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.

Highlighted
Not applicable

Re: What is wrong with this script?

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

Highlighted
Specialist III
Specialist III

Re: What is wrong with this script?

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