Merging a File with a Table

[admin]

Hi all,

I have the following problem with merging a file and a table:

-File Description: (number, duration)
1|1000
1|1100
2|2000

-Table Description: (number, type)
1|A1
1|A2
1|A3
2|B1

I use a Sequential File, a Transformer, and an Oraci8, and in the transfomer i join by number, and the result is:

1|1000|A1
1|1100|A1
2|2000|B1


But, i want to obtain the following:

1|1000|A1
1|1000|A2
1|1000|A3
1|1100|A1
1|1100|A2
1|1100|A3
2|2000|B1

How can i obtain this result?


Thanks in advance.

NSP

[admin]

Hello,

use for the LookupTable an ODBC-Stage and set in the Transformer for the Lookup the Link Property "Refernce link with mult row result set"

regards

Udo