Skip to main content
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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


I have two sheets information in excel

one sheet A have column


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


1 Reply

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:


mapping load [Part of address], customer

from ...excel_sheet_b...;


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

from ...excel_sheet_a...;

talk is cheap, supply exceeds demand