Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Ra

Hi
Can any one help regarding below

INPUT

NAME LOC
Ram hyd
Ram ban
Raj chn
Raj Pun
Sam del

OUPUT

NAME LOC
Ram Hyd ban
Raj chn pun
sam del

Question Posted / ram

3 Answers
11258 Views
HCL, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Raj chn Raj Pun Sam ..

Answer / ashok

TRANSFORMER:
------------
STEP1:
Take 3 stage variables
NAME--->s1
if s1<>s3 then LOC else s2:LOC --->s2
s1--->s3
STEP2:
In derivations s2--->LOC Field
Remove duplicate stage:
-----------------------
Retaining last

Is This Answer Correct ?

7 Yes

0 No

Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Raj chn Raj Pun Sam ..

Answer / vikram

1)Sort the input (name as key),keychange colum =true
we will get
name loc key..
ram hyd 0
ram ban 1
raj chn 0
raj pun 1
sam del 0

2)transformer
stage variable
svVar=if key..=0 then loc else svVar:loc
3) remove duplicate stage
retain duplicate last

Is This Answer Correct ?

0 Yes

0 No

Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Raj chn Raj Pun Sam ..

Answer / venkata ramana

Input Seq File:-

NAME,LOC
Ram,hyd
Ram,ban
Raj,chn
Raj,Pun
Sam,del

seq---Trans---Rem Dups----> Dataset

TRANSFORMER:
------------
STEP1:

Create 3 stage variables like s1,s2,s3

DSLink3.NAME --->s1

If s1<>s3 then DSLink3.LOC else s2:DSLink3.LOC --->s2

s1--->s3

STEP2:

Derivations Column bane

s2------------> LOC

Remove duplicate stage:
-----------------------

Key == NAME

Duplicate To Retain = Last

Output Dataset result:-

NAME LOC
Ram Hyd ban
Raj chn pun
sam del

Is This Answer Correct ?

0 Yes

1 No

Post New Answer