Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm working on a requirement where i have Warehouse, Zone, Aisle, count, ....etc on QVD1 in which i have to cleanse the columns Warehouse, zone, and aisle and retain only the original values.
So, i have another file XLS which has all the required original values of these columns.
When i run a script, i wanna load only those values for Warehouse, Zone, and Aisle which values were present in the XLS file.
Can anyone help.
Please find the attached QVW.
LOAD
Warehouse&Zone&Aisle as Key,
Warehouse as Total_Warehouse,
Zone as Total_Zone,
Aisle as Total_Aisle
FROM
(ooxml, embedded labels, table is Sheet1);
LOAD Warehouse as original_Warehouse,
Zone as original_Zone,
Aisle as original_Aisle
FROM
(ooxml, embedded labels, table is Sheet1)
While Exists(Key, Warehouse&Zone&Aisle);
Hi Manish,
Sry for the late update.
I already have a Key which is ID in Book1. i.e. Total_Warehouse...table.