topic How to add data in to first sheet by considering data in second sheet? in QlikView

How to add data in to first sheet by considering data in second sheet?

Mon, 27 Oct 2014 11:51:59 GMT

Hi,

I have two sheets information in excel

one sheet A have column

address

22 Stavordale Road, Moreton, Wirral, UOI

and another sheet B have columns

Part of address customer
Wirral XXXXXX

would it be possible to add another column in sheet A as Customer by making look up value of column part of address from sheet B

Please can anyone suggest me

Thanks.

Re: How to add data in to first sheet by considering data in second sheet?

Gysbert_Wassenaar — Mon, 27 Oct 2014 18:14:00 GMT

Load the table on sheet B as a mapping table and use the applymap function to add the customer field from the mapping table to the table from sheet A. Something like this:

Map1:

mapping load [Part of address], customer

from ...excel_sheet_b...;

TableA:

LOAD address, applymap('Map1',subfield(address,',',3)) as customer

from ...excel_sheet_a...;