Count of common elements between two string lists

[neeleshapatil1]

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

[Treyson · Accepted solution]

I am unfamiliar with a single tool that does what you are looking for.

However a process like the attached should do what you are looking for.

[CanadaKing]

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