Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

markgraham123
Not applicable

select only required data for a column from another file

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.

2 Replies
MK_QSL
Not applicable

Re: select only required data for a column from another file

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
Not applicable

Re: select only required data for a column from another file

Hi Manish,

Sry for the late update.

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