Page 2 of 2

Re: Produce a multiplication times table for some contest

PostPosted: Wed Dec 14, 2016 6:26 pm
by Robert Sample
if I use a cartesian join how am i supposed to give the key?
Google is your friend. Googling dfsort cartesian join returns 632 results, including hits with sample code from IBM.

Re: Produce a multiplication times table for some training

PostPosted: Thu Dec 15, 2016 1:11 am
by BillyBoyo
If the key you want does not exist, you make it exist.

Use JNF1CNTL and JNF2CNTL datasets to modify each input record to have a "0" (for instance) at position three. The use position 3 for a length of 1 as the "key".

Then, for each record on your F1 input, each F2 record will match.