Discussion Board for collaboration related to QlikView App Development.
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;
Load the Company.xlsx data first, then concatenate the data from CompanyPurchase.
Use also the wizard when loading data from excel for complete syntax.
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.
You need to load E:\Poornima\Company.xlsx first, e.g.
LOAD * from
(ooxml, embedded labels, table is Sheet1);
LOAD * from
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
Hi Nupur ...
First load the Company table first and then give an alias name to it (better)...
hope it will work....