Alteryx community,
I have a record set where Column A contains a date in YYYY-MM-DD format, Column B contains a unique identifier, and Column C contains a string with several eight-digit values separated by an unusual delimiter. What I'd like to do is create a new column (actually, I want to create several but for the purposes of this thread I'll assume whatever process is executed for one new column can be executed for the rest) that returns a value of "1" in the cell if Column C contained a certain value.
(Note: I'd like to avoid using Text-to-Columns because Column C could include dozens of values, so it'd get pretty unwieldy).
An example:
| Date | Unique ID | Value |
| 2019-03-28 | 123456789 | 01010101--**--02020202 |
| 2019-03-28 | 192837465 | 01010101--**--02020202 |
| 2019-03-28 | 987654321 | 01010101--**--05050505 |
| 2019-03-27 | 564738291 | 05050505 |
In the table above, there are four unique IDs across two days. The three unique IDs present on 2019-03-28 have the '01010101' value, while the single unique ID present on 2019-03-27 does not. My hope is to use the SUMMARIZE tool to group by date, then count the number of unique IDs, and count the total number of rows in which the '01010101' value was present. The end result should transform to this:
| Date | Unique IDs | Count of '01010101' |
| 2019-03-28 | 3 | 3 |
| 2019-03-27 | 1 | 0 |
Any help you can provide would be deeply appreciated!
