Using Alteryx Designer - to replace Keyword from Name by Iteration

[i_LKarthick]

Hello Experts, I have two tables as sources. In Table 1, I need to remove over 1000+ keywords that are listed in Table 2. I will iterate through each row of Table 2, and if any string from Table 2 is found in the names of Table 1, I will remove it. The expected output will be stored in Table 3.

Table 1 - which contains Column A with String have 10,000+ records

Name

ABC Inc llc DEF

Plc GFS

DDD Corporate

123 .,#

Table2 Which contains Keyword to be removed

Name

Inc

llc

Plc

.,#

Corporate

Expected Output

Name

ABC DEF

GFS

DDD

123

[alexnajm]

Seems very possible with a Find Replace! Not sure an iterative macro is needed

[aatalai]

aggreed with @alexnajm  but you could also use text pre-processing if you have access to the Intelligence suite, though it does seem to like the comma (",").

[i_LKarthick]

This process removing only one keyword from string. i want to remove all keywords from the list. have to iterate through keyword

[alexnajm]

Whose process? My workflow gets your expected output