Jump to content
  • 0

Using a task to "export" aggregate, unique values




I currently have a table that has:

  • 61,000 Order records associated to a Store Location
  • 49,000 of those Orders are unique

The reason the 49,000 occasionally duplicate is because an Order can be directed to 2-3 different Store Locations.

I have built a Data Page table that:

  • Groups the order records (49,000)
  • Then has an aggregation of "Select Count (Discount [@field:Assigned_Store_Locations])
  • So it will tell me Order #ABC went to 1, 2, or 3+ Store Locations.

Exporting a download this from a Data Page is too large for Excel to open, so instead, I was thinking to create a task that  will On Demand, insert records into a show me all 49,000 Unique Orders in column A (Num_of_Orders) and the count distinct in Column B  (Hops428). 

Result would be:

  • Column A: WSA1517966827
  • Column B: 2

I have most likely built my task wrong...although it let me save, it's erroring out.

Any help would be greatly appreciated!




Link to comment
Share on other sites

1 answer to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...