Jump to content

Libby

Members
  • Content Count

    2
  • Joined

  • Last visited

  1. Hello, 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!
  2. Hello, I have a table I am maintaining of products. It has about 1,000 records in it. One of the fields is SKU, which is a unique identifier for each product. Some users would like to be able to search for several SKUs within the file...how can they (or can they at all?) search for 100002, 102567, 256789 in one search field? I have the parameter today set up as "contains" - should I do something else? I've tried some boolean separators as well like ampersand or * but those didn't work. Any thoughts or ideas I could try? Thank you!
×
×
  • Create New...