topic Re: Repeated Word in Field Value in QlikView

Repeated Word in Field Value

Anonymous — Wed, 20 Sep 2017 16:32:40 GMT

Hi ,

I am having Field As Full Name, in that name is displaying as 'Judy Crawford Crawford', In need to Remove the Crawford Name in the Field Value

Expected Result:

Full name:

Judy Crawford

Re: Repeated Word in Field Value

mostwanted123 — Wed, 20 Sep 2017 16:40:57 GMT

Try this,

=Subfield(FullName,' ',1) &' '&Subfield(FullName,' ',2)

Regards,

Pratik

Re: Repeated Word in Field Value

kaushiknsolanki — Wed, 20 Sep 2017 16:41:11 GMT

Try this.

LOad Data,If(SubField(Data,' ',2) = SubField(Data,' ',3),SubField(Data,' ',1) &' '&SubField(Data,' ',2),Data) as NewField inline [

Data

Judy Crawford Crawford

ABC PQR

];

Regards,

Kaushik Solanki

Re: Repeated Word in Field Value

antoniotiman — Wed, 20 Sep 2017 16:44:15 GMT

Left('Judy Crawford Crawford',Index('Judy Crawford Crawford',' ',-1))

Regards,

Antonio

Re: Repeated Word in Field Value

Anonymous — Wed, 20 Sep 2017 16:48:25 GMT

It creating One more Duplicate word in Field Value

Re: Repeated Word in Field Value

mostwanted123 — Wed, 20 Sep 2017 16:53:10 GMT

example ?

Re: Repeated Word in Field Value

Anonymous — Wed, 20 Sep 2017 16:55:47 GMT

Judy Crawford Crawford Crawford

Re: Repeated Word in Field Value

Anonymous — Wed, 20 Sep 2017 16:56:20 GMT

it is within the Field How can i do this

Re: Repeated Word in Field Value

mostwanted123 — Wed, 20 Sep 2017 16:57:57 GMT

Can you share the expression that you have written ?

Re: Repeated Word in Field Value

kaushiknsolanki — Wed, 20 Sep 2017 17:01:29 GMT

If the word count is different and you want only first two words then try this.

Load SubField(Data,' ',1) &' '& SubField(Data,' ',2) as Newfield inline [

Data

Judy Crawford Crawford Crawford

];

Regards,

Kaushik Solanki

Re: Repeated Word in Field Value

Anonymous — Wed, 20 Sep 2017 17:02:41 GMT

hi Apologize,

Know it working fine ,i have done some mistake in Previous Expression.