logic

chulett · Post by **chulett** » Wed Jul 31, 2013 7:01 am

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?

chulett · Post by **chulett** » Fri Aug 02, 2013 1:26 pm

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

karteekm · Post by **karteekm** » Mon Aug 05, 2013 2:42 am

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.