Re: Produce a multiplication times table for some contest
Posted:
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
Posted:
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.