topic How to Replace the Text values in a Paragraph with Field Values in another Table? in QlikView

How to Replace the Text values in a Paragraph with Field Values in another Table?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I'm having a Paragraph as below in Table

and ID table as below. The task is I need to replace the "Names" in Paragraph with respective ID's

Result I need is as Below

YoussefBelloum — Thu, 21 Jun 2018 12:13:42 GMT

Hi,

you can combine functions like Replace with a Mapping load and Applymap()

sunny_talwar — Thu, 21 Jun 2018 12:15:42 GMT

sunny_talwar — Thu, 21 Jun 2018 12:18:48 GMT

Something like this

Mapping:

Mapping

LOAD * INLINE [

Name, ID

Steve, 1

Rajesh, 2

Vicky, 3

];

Table:

LOAD Paragraph as OriginalParagraph,

MapSubString('Mapping', Paragraph) as Paragraph;

LOAD * INLINE [

Paragraph

"Steve is Retailer, Rajesh is his Consumer, Vicky is Manufacturer and Rajesh is his Worker"

];

Anonymous — Thu, 21 Jun 2018 12:24:17 GMT

Ya Thanks Bro,

It worked

YoussefBelloum — Thu, 21 Jun 2018 12:24:25 GMT

Was thinking about this but with the Replace() function. this is def better