How to track wild entries of field values which are comma separated , based on another comma separated field values ?

[shekhar_analyti]

Hi All ,

How to tracking wild entries of field values which are comma separated , based on another comma separated field values ?

I know this will require subfield function , but i am not really sure about ways to get it done .

Input

Area	Date	Persons_Present_on_Venue1	Persons_who_made_to_Venue2	Group
A1	12/12/2017	Zena,Tom,Kushal	Tom	Alpha
A1	12/12/2017	Tanisha,Bibo,Laura,Sandy	Tanisha,Bibo	Beta
A2	14/12/2017		Anusha	Beta
A3	15/12/2017	Sunny,Weber,Newton	Franklin,Vaibhab	Alpha
A4	17/12/2017	Sunny,Weber,Newton,Krish	Sunny,Newton	Alpha

Note : Anusha is wild entry because it is not present in column Persons_Present_on_Venue1

          same goes for Franklin and Vaibhab

Output

Area	Date	Group	Nbr_of_People_at_V1	Nbr_of_People_from_V1_Reached_V2	Wild_Entry
A1	12/12/2017	Alpha	3	1
A1	12/12/2017	Beta	4	2
A2	14/12/2017	Beta	0	0	1
A3	15/12/2017	Alpha	3	0	2
A4	17/12/2017	Alpha	4	2

Thanks & Regards

Shekar

[sunny_talwar]

Hey look at that... I made it to venue1 and venue2

[sunny_talwar · Accepted solution]

Yeh le mere bhai

[shekhar_analyti]

stalwar1‌ .. Sunny Bhai ... thoughts on above requirement ..

[shekhar_analyti]

Sunny Bhai , how to find wild entries at script level ... in above case