Extracting Multiple words from a string .

[Aryasmank]

Hi all,

I have a text data with almost 400 rows. I want to extract some keywords from the text for analysis. 

In some cases there are more than one keyword in a single row. Two examples are 

1.  " Can we add A3 approved amount in the database ."

2. " But, we can add many A3 metrics in the Central Data , so that we can implement it on Qlik Sense for analysis."

In these examples , A3, Central data & Qlik Sense are keywords that I have to extract . In the first example it easy to extract P3 using Pick() and Wildmatch() like ,   Pick(wild match(text,'*A3*'),A3_key) as Words

but having difficulty for the second example , like if I'm using the above it only extract the first key word .

for now I'm using this expression  (with some more keywords in from the data): 

Pick(wild match(text,'*A3*','*Central Room*','*Qlik*'),A3_key,Central Room , Qlik Sense) as Words

can anyone please help me in this.

Thanks in advance

Regards,

M

[PrashantSangle · Accepted solution]

Try something like below

Test:
Load *,
A3_Key&','&Central_Key&','&Qlik_Key as Final_key;
Load *,
if(WildMatch(Trim(Data),'*A3*'),'A3_Key') as A3_Key,
if(WildMatch(Trim(Data),'*Central Data*'),'Central Data') as Central_Key,
if(WildMatch(Trim(Data),'*Qlik*'),'QlikSense') as Qlik_Key
Inline [
ID, Data
1,"Can we add A3 approved amount in the database"
2, "But, we can add many A3 metrics in the Central Data , so that we can implement it on Qlik Sense for analysis."
];

Regards,

Prashant Sangle