View previous topic :: View next topic
|
Author |
Message |
rejikonkara
New User
Joined: 07 Dec 2006 Posts: 2 Location: India
|
|
|
|
Hi,
I have a Store file (file A) which has the records in the format
0001
0002
0003
I have a category file (file B) which has records in the format
001
003
004
I need to have a file which has all the Store Category combinations as mentioned below. Is this possible using SORT / ICETOOL? Here I don't have a common field in the files to splice from.
0001001
0001003
0001004
0002001
0002003
0002004
0003001
0003003
0003004 |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
That's a cartesian join. SPLICE can't do that. |
|
Back to top |
|
|
rejikonkara
New User
Joined: 07 Dec 2006 Posts: 2 Location: India
|
|
|
|
Thanks Frank for the quick reply. |
|
Back to top |
|
|
|