Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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"
];
Hi,
you can combine functions like Replace with a Mapping load and Applymap()
May be use MapSubstring
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"
];
Ya Thanks Bro,
It worked
Was thinking about this but with the Replace() function. this is def better