topic Extract string within text in Qlik sense in App Development

Extract string within text in Qlik sense

LP27 — Sat, 16 Nov 2024 18:04:59 GMT

Hi Qlikers,

Here is the scenario where I would need some idea's on-

I have column Description in one Table and Vendor No in another Table.

example :-

Description Table

No	Description
1	R555-10034 Alter state
2	R777-10045 Change state
3	56785789907909

Vendor Table

Vendor No

10034

45654

23435

10045

So now I have to extract the string from Description Table if it contains the exact vendor No from Vendor Table.

Example : I need to create New Column as shown below-

No	Description	New Column
1	R555-10034 Alter state	10034
2	R777-10045 Change state	10045
3	56785789907909	-

Note : Only if Vendor No exist in the description Column it should add to new Column as shown above.

I have also tried this condition- if(wildmatch(Description, Vendor No),Vendor No). This did not work!

Let me know how to achieve this, have tried out my best!

Thanks in Advance🙂

Re: Extract string within text in Qlik sense

sunny_talwar — Mon, 21 Sep 2020 19:02:29 GMT

Try this

VendorMapping: Mapping LOAD [Vendor No], '/'&[Vendor No]&'\'; LOAD * INLINE [ Vendor No 10034 45654 23435 10045 ]; Table: LOAD *, TextBetween(MapSubString('VendorMapping', Description), '/', '\') as [New Column]; LOAD * INLINE [ No, Description 1, R555-10034 Alter state 2, R777-10045 Change state 3, 56785789907909 ];

Re: Extract string within text in Qlik sense

LP27 — Tue, 22 Sep 2020 07:44:55 GMT

Wow! that solved my issue.

Thanks @sunny_talwar