Hi,
My application needs an output of this kinf.
COLUMNA COLUMNB
1
2
Using Inner Join in the Join Stage
Moderators: chulett, rschirm, roy
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.
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.
-
- Charter Member
- Posts: 130
- Joined: Mon Sep 06, 2004 3:05 am
- Location: Dubai,UAE
-
- Charter Member
- Posts: 130
- Joined: Mon Sep 06, 2004 3:05 am
- Location: Dubai,UAE
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: