topic Re: Join if Value1 Contains Value2 in QlikView

Join if Value1 Contains Value2

Anonymous — Thu, 30 Aug 2018 18:06:57 GMT

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 — Thu, 30 Aug 2018 18:27:45 GMT

You can create a field in table 1 as -

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

and join it with the second table.

MarcoWedel — Thu, 30 Aug 2018 23:06:13 GMT

Hi,

maybe this helps:

regards

Marco