Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
STORE_ID,
STOCK
Date
FROM [lib://STK.qvd]
(qvd);
LOAD
StoreName
FROM [lib:// Copy.xlsx]
(ooxml, embedded labels, table is Sheet1);
-----------------------------------------------------------------------------------------
======================================================
i have these 2 tables how can i merge the id for the store from the Frist one and the name from the sconed one and make sure that the data dont change or anything even tho the other table(excel table) only have the name of the stores
i want somthing like this to use in the first table
0434 - Name
0432 - Name
0324 - Name
like this to use in the first table with the data in it.
can anyone help with this?
If these are your files, there's no way to join the data, since there is no common key.
@Or what if i had a filed called STORE_ID in the the second table? that had the same store code in it ?
Then it wouldn't be a problem - you could just join the tables:
Load * From Table1;
Left Join
Load * From Table2;
Or use a mapping load if you prefer.
STORE_ID ,
STOCK_QTY ,
ApplyMap('StoreMapping', STORE_ID) as StoreNamE
FROM [lib://STK.qvd]
(qvd);
StoreMapping:
MAPPING LOAD
STORE_ID,
StoreNamE
FROM [lib:// Copy.xlsx]
(ooxml, embedded labels, table is Sheet1);
i keep getting this :
The following error occurred:
ApplyMap error:
map_id not found
@Or
You've got those in the wrong order. You can't apply a map from a table you haven't loaded yet...