Forum Discussion

joschultz's avatar
joschultz
Advocate II
10 years ago
Solved

Filter

    I have a column that I need to group by an ID number.  I have a list of 25 IDs that I need to split into two groups  but then would like the rest put into a third group so that I can slice on t...
Need Help
  • ImkeF's avatar
    ImkeF
    10 years ago

    Performance is best if you do this task in the query editor:

     

    Start in your sales table and merge it with the table containing the IDs for EDU and MIL on Offer Id. Expand the result on one field only: Portal.

    This will allocate EDU and MIL to the matching items and leave null for all others. Then replace null by the name you want this group to be named.

joschultz's avatar
joschultz
Advocate II
10 years ago

So here is my table that I have for an EDU or Mil Portal. 

 

 

Then in my sales data I have a column called Item Offer ID

 

 

I want the Ids in the sales table to be either EDU or MIL based on the first table and then all other values in that sales data to be labled "general" so that I can slice off of those 3 categories.

 

Thank you,

 

JOseph

 

 

 

 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

joschultz - So, is there anything in the "Item Offer ID" that distinguishes an EDU versus a MIL or is it purely based on the Item Offer ID individually? If the latter, then your best bet is to build a table of the "Item Offer ID" and the category like:

 

Item Offer ID,Category

45322908501,EDU

45188472001,MIL

...

 

Then you can relate that table to this new table and Bob's your uncle!