Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
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?

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.
   

1 Reply
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand