Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Search for a substring in next column

i_LKarthick
5 - Atom

Hi,

good day!.

I have Column A - which has paragraph about product. Similarly I have Column B which contain many rows.

Need to check is there any string Match in Column B.if any substring match then I have to pull "Serial No" Value to output sheet.

 

Source:

 Serial NoColumn A
 1Product1 is available, Product 2 is also available.

 

Serial NoColumn B
1Product available are Product1,Product2,product3
2Base Product is Product5
3Product1 also available
4Product2

 

 

Expected Output:

Column AOutput(Serial No)
Product1 is available, Product 2 is also available.1
Product1 is available, Product 2 is also available.3
Product1 is available, Product 2 is also available.4

 

 

2 REPLIES 2
Amol_Telore
11 - Bolide

Hey @i_LKarthick 

 

Here is my solution. Hope it solves your concern.

 

Amol_Telore_0-1659790280485.png

 

i_LKarthick
5 - Atom

Hi,

Thanks for the solution. it work fine for me. Now I got one more new scenario,

I have Column A - which has paragraph about product.  In Column B have to check is there any string Match .if any substring match then I have to pull "Serial No" Value to output sheet.

 

Source:

 Serial NoColumn A
 1Product1 is available, Product 2 is also available,Pro,123,ABC.

 

Serial NoColumn B
1Product available are Product1,Product2,product3
2Base Product is Product5
3123
4Pro
3Product1 also available
4Product2

 

 

Expected Output:

Column AOutput(Serial No)
Product1 is available, Product 2 is also available.1
Product1 is available, Product 2 is also available.3
Product1 is available, Product 2 is also available.4



Labels