I am in the process of trying to import data from a CSV file and add it to a relational database. In the CSV file there are two columns that are as following:
- List of Approvers - Which has a list of personnel that can approve a record(Row)
- Approvers - The actually approver of the record(Row)
I am wanting to create a flag that would verify that the actual approver was in approvers list column. Below is an picture of what a final table might look like.

Below is how it is done in SQL with Sample Data.
Create Table #Temp
([List_ofApprover] nvarchar(135),
[Approvers] nvarchar(125));
INSERT INTO #Temp VALUES
('bgates,sjobs, or tcook','sjobs'),
('mduncan','mduncan'),
('mcook,jdavis, or hsmaith','mdavis'),
('triddle,hpotter','hpotter'),
('martha & Marry','martha'),
('martha & Marry','marry')
Select *
,CASE WHEN [List_ofApprover] LIKE CONCAT('%',[Approvers],'%') Then 'Yes' Else 'No' End [Approver in List]
From #TempI created some sample data in Alteryx and attached the flow file. Does anyone have a good suggestion to help me create this flag in my Alteryx workflow? Thanks in advance for all of the help.