DSXchange

Welcome aboard. First I'm curious... what have you tried so far? Do you have any thoughts on how to approach this we can discuss?

Hmmm... perhaps not. Did you get this figured out or are you still looking for some help with it?

first parent CITY_LOG lookup with CITY_LOG_CHILD based on key column : CITY_LOG_ID in lookup set multiple rows returned from link .
then fetch R_WELL_PASS_ID from child CITY_LOG_CHILD table,
this should process from COPY Stage to two output links.
one link pass through aggregator,
set
group by :CITY_LOG_ID
type : calculation
minimum value output column :R_WELL_PASS_ID and name to is MIN_R_WELL_PASS_ID

then lookup :
second link of copy stage and reference link is from aggregator stage based on : CITY_LOG_ID fetch MIN_R_WELL_PASS_ID
then pass through Remove duplicate stage key :CITY_LOG_ID.


from the output lookup with reference table: R_WELL_PASS based on src: MIN_R_WELL_PASS_ID and R_WELL_PASS.R_WELL_PASS_id fetch Abbrevation.
=================================================================================================================================================================
CITY_LOG_CHILD[CITY_LOG_ID,R_WELL_PASS_ID]
|
| -----multiple rows returned from link
source[fileset]--> lkp[CITY_LOG_ID] ---Fetch R_WELL_PASS_ID----->copy--------------link1
----------link2

linkk1------------aggegator[group by : CITY_LOG_ID, column of R_WELL_PASS_ID, minimum value output column :R_WELL_PASS_ID name it as MIN_R_WELL_PASS_ID].

link1[CITY_LOG_ID,MIN_R_WELL_PASS_ID] R_WELL_PASS[R_WELL_PASS_ID,ABBREVIATION]
| |
link2-----lookup [Key:CITY_LOG_ID] fetch MIN_R_WELL_PASS_ID ----------->Remove Duplcate stage[CITY_LOG_ID]------>lookup[key:MIN_R_WELL_PASS_ID,R_WELL_PASS_ID]-----------Fetch Abbreviation.