vlookup in qlikview

[tripatirao]

Dear All,

I need to add a column in qlikview which will display the all the blocked vendor

I have 3 columns in the attached excel sheet

user wants add another column in sheet ,users wants to find the blocked vendor

Please find the attached excel sheet.

[micheledenardi]

How we can identify the "blocked vendors" ?

[tripatirao]

Hi,

Thanks for your quick reply.

My vendor code column has both Blocked and unblocked vendor.

Unblocked vendor code already given by user,

my requirement is  match the  value of  unblocked vendor  column with value of vendor code column.

if matching ,then leave it else unmatching values should be displayed blocked vendor column.

[micheledenardi]

Try this:

UnBlockedVendor:

Mapping

Load distinct

  [Unblocked vendor],

  1

from [Sample.xlsx] (ooxml, embedded labels, table is Sheet1);

LOAD [Vendor Code],

     [Vendor Name],

     [Unblocked vendor],

     [Blocked vendor],

     applymap('UnBlockedVendor',[Vendor Code],0) as [Flag Blocked Vendor]

FROM [Sample.xlsx] (ooxml, embedded labels, table is Sheet1);