select only required data for a column from another file

[markgraham123]

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.

[MK_QSL]

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);

[markgraham123]

Hi Manish,

Sry for the late update.

I already have a Key which is ID in Book1. i.e. Total_Warehouse...table.