Using Inner Join in the Join Stage

Tasneem · Post by **Tasneem** » Thu Oct 06, 2005 4:58 am

Hi,

My application needs an output of this kinf.

COLUMNA COLUMNB
1
2

Tasneem · Post by **Tasneem** » Thu Oct 06, 2005 5:05 am

Hi,
Sorry, due to an internal error my message got posted before completion.

My application has the following input:

COLUMNA COLUMNB
1 1
2 2
3 3

Then Output needs to be produced like:
COLUMNA COLUMNB
1 1
1 2
1 3
2 1
2 2
2 3
3 1
3 2
3 3

I have used an Inner Join in the Join Stage where I get an output of this kind:
COLUMNA COLUMNB
1 1
1 2
1 3
2 2
2 3
3 3

Please let me know the solution.

Sunshine2323 · Post by **Sunshine2323** » Thu Oct 06, 2005 5:51 am

Hi,

Introduce a dummy column in both the files and use the dummy column as the key

Hope this helps:)

Sunshine2323 · Post by **Sunshine2323** » Thu Oct 06, 2005 6:47 am

Hi,

Introduce a dummy column in both the files and use the dummy column as the key

Hope this helps:)

ray.wurlod · Post by **ray.wurlod** » Thu Oct 06, 2005 4:56 pm

Use Full Outer Join