Question about Loop & Reduce

[hobanwashburne]

How do I distribute the same reduced document to multiple people?

For instance: In the following both Steve and Joe are to receive the document for Industry B

I created the following table in the script

Industry, UserName

A, Bob

B, Steve

B, Joe

C, Nick

D, Ed

If I loop and reduce on Industry and make the document name Dashboard %Industry% won't the document Dashboard B that is distributed to Steve be overwritten by Dashboard B that is distributed to Joe?

[#2]

Create concatenated field in the data model & use the new field on Loop & Reduce

Script: Industry&'_'&UserName AS LoopReduceField

QEMC: Dashboard %LoopReduceField%

[#3 · Accepted solution]

Yes, It will over write dashboards.

If possible create a composite key based on Industry ID & User ID & Make sure it is unique. so that you won't run into any dashboard over write issues.

Thanks

Brad.