topic Re: Create keywords(BUSINESS) from column data. in QlikView

Create keywords(BUSINESS) from column data.

jim_chan — Sun, 30 Oct 2016 19:53:03 GMT

Hi guys,

i wanted to create a keyword field from 1 of my existing field. The existing field is business_description where it contains long desvcription.

So i want to create a keywords list box, pick up some words from each of the description .

at the loading script, i've wrote.

If ( business_desc = '*Food*' , 'About Food' , Null() ) as Keywords.

When I loaded the script, i have found that the keywords list box is empty! no data!

So, my script is wrong?

Rgds,

Jim

Re: Create keywords(BUSINESS) from column data.

MarcoWedel — Sun, 30 Oct 2016 19:58:51 GMT

If ( business_desc like '*Food*' , 'About Food' , Null() ) as Keywords

Re: Create keywords(BUSINESS) from column data.

jim_chan — Sun, 30 Oct 2016 20:02:17 GMT

you are right!

Re: Create keywords(BUSINESS) from column data.

MarcoWedel — Sun, 30 Oct 2016 20:10:01 GMT

Hi,

if you have a table of keywords, then another solution might be:

Subfield Function

hope this helps

regards

Marco

Re: Create keywords(BUSINESS) from column data.

jim_chan — Sun, 30 Oct 2016 20:25:08 GMT

Hi Marco,

I realised there's a description like - Chili Chicken and another one is Chili Paste Chicken.

I need to create a keyword that it can find both of this description. Can i write:

if ( business_desc like '*Chili* + '*Chicken*' , 'Spicy Chicken' , Null() ) as Keywords

Re: Create keywords(BUSINESS) from column data.

MarcoWedel — Sun, 30 Oct 2016 20:28:17 GMT

Hi,

you could try

if ( business_desc like '*Chili*Chicken*' , 'Spicy Chicken' ) as Keywords

regards

Marco

Re: Create keywords(BUSINESS) from column data.

jim_chan — Mon, 31 Oct 2016 07:07:08 GMT

how mnay keywords can i add in??? can i add more than 2 keywords, if yes, how should it looks like?

Re: Create keywords(BUSINESS) from column data.

jim_chan — Mon, 31 Oct 2016 08:00:33 GMT

Hi guys,

i have a situation as such, and i tried to add it in the loading script, is it possible?

(*Personnel*|*retain*) ?

Rgds

Jim

Re: Create keywords(BUSINESS) from column data.

MarcoWedel — Mon, 31 Oct 2016 21:05:13 GMT

can you please post some different examples of your source strings and keyword combinations as well as your expected result to create a sample application with?

thanks

regards

Marco

Re: Create keywords(BUSINESS) from column data.

jim_chan — Tue, 01 Nov 2016 05:40:29 GMT

Hi Marco,

here's the screenshot. i have also attached sample data.

Here's my script :

final_survey:

load

If ( survey_desc like '*lamb*' , 'lamb' ,

If( survey_desc like '*chili**CHICKEN*' , 'chili chicken' ,

If( survey_desc like '*chicken**beef**lamb*' , 'chicken and beef and lamb' ,

Null() ))) as keywords

Resident survey;

drop table survey;

now this one is not functioning - If( survey_desc like '*chicken**beef**lamb*' , 'chicken and beef and lamb'.

i want to have when user choose chicken and beef and lamb from the listbox, then it should show me desriptions that has chicken,beef and lam words.

rgds

jim

Re: Create keywords(BUSINESS) from column data.

jim_chan — Tue, 01 Nov 2016 16:10:24 GMT

Hello , marco?

Re: Create keywords(BUSINESS) from column data.

MarcoWedel — Tue, 01 Nov 2016 20:17:44 GMT

Hi,

depending on your requirements one solution could be:

final_survey:
LOAD *,
    If(survey_desc like '*chiken*beef*lamb*', 'chicken and beef and lamb',
        If(survey_desc like '*chili*CHICKEN*', 'chili chicken' ,
          If(survey_desc like '*lamb*', 'lamb',Null() ))) as keywords 
Resident survey;

DROP Table survey;

So just change the order of your nested if() functions according to the priority you wish.

'*lamb*' in this case only becomes relevant if the string is NOT like '*chiken*beef*lamb*' (note the chicken typo in your example).

hope this helps

regards

Marco

topic Re: Create keywords(*BUSINESS*) from column data. in QlikView

Create keywords(*BUSINESS*) from column data.

Re: Create keywords(*BUSINESS*) from column data.

Re: Create keywords(*BUSINESS*) from column data.

Re: Create keywords(*BUSINESS*) from column data.

Re: Create keywords(*BUSINESS*) from column data.

Re: Create keywords(*BUSINESS*) from column data.

Re: Create keywords(*BUSINESS*) from column data.

Re: Create keywords(*BUSINESS*) from column data.

Re: Create keywords(*BUSINESS*) from column data.

Re: Create keywords(*BUSINESS*) from column data.

Re: Create keywords(*BUSINESS*) from column data.

Re: Create keywords(*BUSINESS*) from column data.

topic Re: Create keywords(BUSINESS) from column data. in QlikView

Create keywords(BUSINESS) from column data.

Re: Create keywords(BUSINESS) from column data.

Re: Create keywords(BUSINESS) from column data.

Re: Create keywords(BUSINESS) from column data.

Re: Create keywords(BUSINESS) from column data.

Re: Create keywords(BUSINESS) from column data.

Re: Create keywords(BUSINESS) from column data.

Re: Create keywords(BUSINESS) from column data.

Re: Create keywords(BUSINESS) from column data.

Re: Create keywords(BUSINESS) from column data.

Re: Create keywords(BUSINESS) from column data.

Re: Create keywords(BUSINESS) from column data.