Hi,
Is there any kind of intersection function available like Python in Alteryx?
Example - given below
I would like to get count of common elements between two concatenated lists (Col B and Col C) compared for each company name.
Appreciate if someone can confirm here. I don't to use python code but want to use native Alteryx tools
Solved! Go to Solution.
Hi,
I have these below tables:
Table A
Column_1 | Result |
A and B of C | 1, 2 |
D and E of F | 2 |
G and H | 3 |
J | 4 |
K and A of N | 4, 1, 2, 5 |
M, P and S | 5, 6, 7 |
A, G, M, P, And S | 1, 2, 3, 5, 6, 7 |
X | 8 |
Table B
ID | Description |
1 | A, B and C charts in alphabet |
2 | A, B, C, D, E and F charts in alphabet |
3 | G, H and I charts in alphabet |
4 | J, K and L charts in alphabet |
5 | M, N and O charts in alphabet |
6 | P, Q and R charts in alphabet |
7 | S, T and U charts in alphabet |
8 | V, W and X charts in alphabet |
After using find\replace function to remove conjunction words [and, of, …] in [Column1] in Table A, I want to use [Column1] values in Table A to identify all records with matching words in Table B [Description] column and place results of all partially or fully matching records ID’s (from Table B) in [Result] column in Table A as presented.
How could I do that in Alteryx?
Thanks