AnsweredAssumed Answered

I need to create a process which will consume two files and create a cross product.

Question asked by igreenberg846758 on Nov 1, 2016
Latest reply on Nov 2, 2016 by igreenberg846758

Neither file has a key element to link it to the other. For example, if one file has 2 records and the other has 4 records, then the resulting file should have 8 records.

 

File 1

__________________

1,Mike,456

2,Jim,789

 

File 2

__________________

a,Smith,74

b,Cruz,56

 

Resulting file

__________________

1,Mike,Smith,456

1,Mike,Cruz,456

2,Jim,Smith,789

2,Jim,Cruz,789

Outcomes