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
