Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Data exclusion

Scheruku
8 - Asteroid

Hello All,

 

We are trying to exclude the data if there are is one code "99" and any other code "xx" within the same month for each no. Attached the file ad below the output. Please help.

 

Output:

 

NoMonthCD
131123345555-B11111111Feb99
131123345555-B11111111Mar99
131123345555-B11111111Apr99
131123345555-B11111111May99
131123345555-B11111111July99
131123345555-B11111111Aug99
131123345555-B11111111Sep99
131123345555-B11111111Aug99
131123345555-B11111111June99
138888888888-B29999999Mar57
133333333333-B21333333May99
133333333333-B21333333July99
133333333333-B21333333Aug99
133333333333-B21333333Sep57
133333333333-B21333333Sep99
135555555554-B223444444Apr99
131123345555-B11111111June99

 

 

1 REPLY 1
MarqueeCrew
20 - Arcturus
20 - Arcturus

@Scheruku,

 

One way of doing this is:

 

  1. SUMMARIZE data with
    1. Group by No & Month
    2. Count CD
  2. FILTER Count >1
  3. JOIN the original data to the FILTER output (True) on No & Month
    1. Connect the L anchor to the next tool (e.g. BROWSE)

 

You will use the join to filter out the rows where there are multiple different CD values.  Perhaps you will want to use COUNT DISTINCT in the summarize tool in case you allow for multiple equal CD values.  Also, you will want to include YEAR in the process if you have more data.

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels