D Hemakumar

• Apr 24th, 2015

 

source---->columngenarator--------->transformer---->target
generate the two columns col1 and col2 and generate the sequence numbers for both columns in transformer write constraint col1>col2
take the source destination and distancefare columns in the output link

i hope this may work

Pavan Kumar

• May 7th, 2015

 

Source >> Pivot enterprise {(horizontal pivot) combine both source and destination} >> remove duplicate stage >> Pivot enterprise stage {(vertical pivote) group by fare and set array size to 2, this will split the data into two columns (source and destination column)} >> Dataset/ Fileset.

sreeja

• Jul 15th, 2015

 

source -> Sort -> filter > output
We can have sort stage and set the property create key change column give it a name "KeyChange".Map this column to output link.
Put a filter stage after sort satge and write a where condition KeyChange =1 and set output Reject =False
Hope this will work

bimaljsr@gmail.com

• Aug 10th, 2015

 

See if this works

Code
 


SELECT a.Source1,a.destination,b.destination, 2*a.distance,2*a.fare 


FROM train A, train B


WHERE (A.Source1=B.destination


AND A.destination=B.Source1)

sreenivas

• Jun 21st, 2016

 

source
**************
city1,city2,distance
hyd,pune,500
del,mum,1000
hyd,pune,500
blore,viza,700
del,mum,1000
mum,pune,300
target
*******************
city1,city2,distance
hyd,pune,500
del,mum,1000
blore,viza,700
mum,pune300
ANS) seq---->Pivot---->RD----->Pivot----->DS
first take PIVOT Horizontal -->pivot properties -->city1,city2(derivation)
In RD we can give combination of key =city & key=distance
In Pivot Vertical select Group by Distance & Pivot city.
we will get out put
i tried this its me working fine..

Naga Prasad

• Jul 7th, 2016

 

I Think Sreenivass soultion will work.

Kumar Sonal

• Jul 8th, 2016

 

1.Take another column called KEY in transformer. Derivation for key will be like If Source
2. Use sort stage to remove duplicate values on the basis of key column derived in transformer

Alam

• Feb 15th, 2018

 

Ans--> Seq_File------>Sort------>Filter------->Seq_file
Sort Stage--->Generate key change column(it return for first value 1 and for duplicate 0) then used filter stahe
Filter Stage----> Filter by Key change column=1.
I think you will get the result.

Bhargav

• Mar 2nd, 2018

 

I don't think you got the output for city in the format of SRC1-DES1-SRC1 (I mean two city names)? I tired your way but didn't get the expected output.