2 Replies Latest reply: Jul 2, 2015 11:11 AM by Mark Graham RSS

    select only required data for a column from another file

    Mark Graham

      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.