Check if text field contains list of codes, and update appropriate column

[Jath]

I've got a large dataset of text fields (~450k). I've also got a list of ~700 codes. I want to check if these 700 codes are contained in each of the text fields. If so, I want to create a column for that code which will have a '1' value against every entry that contains that code.

Is this realistically doable in alteryx? I'm thinking in python I would have to do some for-if-loop.

Currently thinking along the lines of using a multi field formula somehow, but not quite sure  how.

[binuacs]

@Jath Find and Replace tool would be an option for your usecase

[Yoshiro_Fujimori]

Hi @Jath ,

It sounds that Batch Macro would help you.

You feed each one of the code to the macro,

append the code to each row of the text field with Append Field,

check if the text field contains the code with Formula tool.

For details of Batch Macro, you may want to check the Interactive Lesson for Batch Macro.

Good luck.