merge the two files

[murari83.ds]

Hi


I hava a two seq files

file1
ENO,ENAME
101,ABC
102,BBB
103,DDD

FILE2
SAL,AGE
50000,45
7000,66
8000,77


Using this data i want to merge the file, i don"t have a key colum.



Thanks

[ray.wurlod]

Use a Column Generator stage to generate sequential integer keys on each link (outputs from the source files), and use that as the join key.

[murari83]

[quote="murari83.ds"]Hi


I hava a two seq files

file1
ENO,ENAME
101,ABC
102,BBB
103,DDD

FILE2
SAL,AGE
50000,45
7000,66
8000,77



I sove this problem using this


seqfile1----->surrogatekey---
merge---->seqfile

seqfile2--> surrogate key------


my problem is

i want to target out like this, any posibility

out put

ENO ENAME SAL AGE
101 ABC 8000 77
102 BBB 7000 66
103 DDD 50000 45


thanks

[Havoc]

Hi


I hava a two seq files

file1
ENO,ENAME
101,ABC
102,BBB
103,DDD

FILE2
SAL,AGE
50000,45
7000,66
8000,77



I sove this problem using this


seqfile1----->surrogatekey---
merge---->seqfile

seqfile2--> surrogate key------


my problem is

i want to target out like this, any posibility

out put

ENO ENAME SAL AGE
101 ABC 8000 77
102 BBB 7000 66
103 DDD 50000 45


thanks

'any possibility' = cartesian product/join?

[mcs_dineshm]

Use Two SUrrogate key generator one after each sequential file stage, then use a merge stage and in the merge stage output mapping remove the key that is generated using surrogate key generator. note tat while using surrogate key generator use same name as key for both surrogate key generators.

[murari83]

Hi
i want to target out like this, any posibility

out put

ENO ENAME SAL AGE
101 ABC 8000 77
102 BBB 7000 66
103 DDD 50000 45


thanks

[jhmckeever]

What are your rules for joining the data?

From your example we could infer you are intending to join Ascending ENO on descending SAL - Right?

J.

[murari83]

yes,

ENO ascending and SAL Decending,meand


first eno records to Sal last record






thanks

[sanath1234]

Hi


I hava a two seq files

file1
ENO,ENAME
101,ABC
102,BBB
103,DDD

FILE2
SAL,AGE
50000,45
7000,66
8000,77


Using this data i want to merge the file, i don"t have a key colum.



Thanks

TRY TO USE FUNNEL STAGE

[sanath1234]

Hi


I hava a two seq files

file1
ENO,ENAME
101,ABC
102,BBB
103,DDD

FILE2
SAL,AGE
50000,45
7000,66
8000,77


Using this data i want to merge the file, i don"t have a key colum.



Thanks

TRY TO USE FUNNEL STAGE//quote]

[vikasjawa]

Hi,
Sort file1 using ENO and file2 using SAL.Using column generator create a Key column for both these file and then join these.Simply remove the key column in the next stage.