Join if Value1 Contains Value2

[Anonymous]

Field            Values

________________________

TABLE1

Line         |  Coaxial@Robertstown, Fiber@Steelburgh, Fiber@Robertstown

Location   |  Robertstown, Steelburgh, Robertstown

JOIN TABLE2 to TABLE1

Cable      | Coaxial, Fiber

Speed     | 100mbps, 1gbps

I need to join the 2nd table to the first table based on 'Line' containing 'Cable'.

Ideally this is the output

Line           Coaxial@Robertstown, Fiber@Steelburgh, Fiber@Robertstown

Location     Robertstown, Steelburgh, Robertstown

Speed        100mbps, 1gbps, 1gbps  

[neelamsaroha157]

You can create a field in table 1 as -

Left(Line, index(Line, '@')-1) as Cable

and join it with the second table.

[MarcoWedel]

Hi,

maybe this helps:

Grouping List Box values

Match string to substring from another table

if condition

Keyword Mapping with Description

Multi-wildmatch on Text

How load necessary information from unstructured column?

regards

Marco