topic select only required data for a column from another file in QlikView

select only required data for a column from another file

markgraham123 — Thu, 02 Jul 2015 14:39:59 GMT

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.

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

MK_QSL — Thu, 02 Jul 2015 14:42:46 GMT

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

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

markgraham123 — Thu, 02 Jul 2015 15:08:17 GMT

Hi Manish,

Sry for the late update.

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