Interesting question. You could try this:
- Do a Loop & Reduce on the first field.
- Then do a Loop & Reduce on each file that was outputted by the 1st Loop & Reduce. Make sure your naming conventions on this 2nd Loop & Reduce include the values from BOTH fields (for example, Dept1_value - Dept2_value - 01; Dept1_value - Dept2_value - 02; etc).
- Once both operations have run once, create a distribution task that will distribute the good files (i.e. the ones where the values of Dept1 & Dept2 match up--you can tell this by the file names) to the proper users so they can see them in the AccessPoint.
This is kind of cumbersome, but I can't think of another way to do what you require.
Thanks for you reply !
Unfortunately , my current reduction job creates some 1000 files and takes very long time.
Just for the sake of getting reduction job done ,I am linking these 2 datasets together and I found a way to break the link after the reduction job.
On document open macro,I am doing partial reload and in the script I am dropping that key field off if it's a partial reload.After reduction the key field will have only one value (this is the field used for reduction) so it just takes few seconds.