View previous topic :: View next topic
|
Author |
Message |
mgl
New User
Joined: 12 Dec 2005 Posts: 29 Location: Belgium
|
|
|
|
I need to combine fields of 3 files on a key and don't manage to achieve it with splice.
Datasets are FB with key in column 1.
file1 contain following records:
1A
2B
3C
4D
file2 :
1K
1L
1M
2N
2O
3P
file3:
1R
1S
1T
2U
I expect the following data in my result file :
1AKR
1AKS
1AKT
1ALR
1ALS
1ALT
1AMR
1AMS
1AMT
2BNU
2BOU
3CP
4D
MicheL |
|
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 |
|
|
|