How to create few additional column by deriving values from other columns on a matching field value

[bickyqlik]

Hi,

I have a situation where I need to add few columns to a load script or in sheet table creation view where i need to get values from matching field value

ASSET_ID	CITY	LOCATION	STAFFCOUNT	ZIP	RS_ID	RS_CITY	RS_STAFF_COUNT	_RS_ZIP
A1	chennai	c1	5	12547	A5	PUNE	47	25478
A2	bangalore	b1	9	12563	A7
A3	delhi	d1	89	25478	A1
A2	bangalore	b2	58	25698	A2
A5	pune	p1	47	25478	A3
A6	mumbai	m1	12	25879	A5
A7	surat	s	54	25412	A6
A8	varanasi	v1	52	23654	A7
A5	pune	p2	58	25698	A8
A1	chennai	c2	56	256325	A2
A6	mumbai	m2	53	25147	A3
A7	surat	s	54	25412	A1
A8	varanasi	v1	52	23654	A7
A5	pune	p2	58	25698	A5

In the above table, first 6 column are available. The last three columns need to be get populated. The first one is an example. RS_ID is the searchable column and load script or at sheet design view, the RS_ID value will search on column ASSET_ID and if found a match then take the CITY value as RS_CITY, STAFFCOUNT as RS_STAFF_COUNT and ZIP as RS_ZIP. 

This can be either done on Load script level or in design sheet where I can add the column and generate the required values

Appreciate any quick help on this.

Regards

Bicky

[Or · Accepted solution]

Sounds like you might be looking for Mapping Load .

You could also just load the additional tables with a LEFT JOIN prefix to the original table.