field values

[nareshthavidishetty]

Hi all ,

I have a field  datasource and values in it is

airtel

airtel 3mbps

airtel 5mbps

vodafone 3mbps

voda

vodafone

now i want to show

airtel

airtel 3mbps

airtel 5mbps  all should be as one unique name airtel so as vodafone

can anyone help me

[Anil_Babu_Samineni]

Finally, How you want to see in output?

[nareshthavidishetty]

airtel

vodafone

bsnl

aircel

like this i want my output

[prma7799]

Please share example output...

[nareshthavidishetty]

I have a field  datasource and values in it is

datasource:

airtel

airtel 3mbps

airtel 5mbps

vodafone 3mbps

voda

vodafone

aircel 5mbps

aircel

aircel 3mbps

bsnl 2mbps

bsnl

output should be

datasource:

airtel

vodafone

aircel

bsnl

[Chanty4u]

am not sure but try this.

Network:

load * Inline [

Data

airtel

airtel 3mbps

airtel 5mbps

vodafone 3mbps

voda

vodafone

];

LOAD *

, subfield( Data,' ',1) as firstWord

Resident Network;

[qlikview979]

Hi

Do like this

sunfield(datasource,' ',1) as datasource

[Anil_Babu_Samineni]

May be this?

LOAD datasource, If(SubStringCount(datasource,'airtel'),'airtel', If(SubStringCount(datasource,'voda'),'voda', If(SubStringCount(datasource,'bsnl'),'bsnl'))) as datasource1 Inline [

datasource

airtel

airtel 3mbps

airtel 5mbps

vodafone 3mbps

voda

vodafone

aircel 5mbps

aircel

aircel 3mbps

bsnl 2mbps

bsnl

];