What is wrong with this script?

[#1]

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;

[#2]

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.

[#3]

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]

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