issue regarding sub field

[#1]

for example if i have a table like below

mobiles               features

i phone                 wifi,bluetooth,

blackberry             wifi,whatapp

moto                    hotspot,2gb ram

micromax             wifi,facebook

now i want to create a list box featuring only wifi

thanks in advance

[Chanty4u]

Hi,

Try below script

a:

LOAD * INLINE [

    mobiles, features

    i phone, wifi, bluetooth

    blackberry, wifi, whatapp

    moto, hotspot, 2gbram

    micromax, wifi, facebook

];

Result:

LOAD

mobiles,

subfield(features ,',') as fea

Resident a

Where features like 'wifi';

[ishanbhatt]

Hi Kenchala,

mobiles              features

i phone                wifi,bluetooth,

blackberry            wifi,whatapp

moto                    hotspot,2gb ram

micromax            wifi,facebook

now i want to create a list box featuring only wifi.

So you need to use Subfield function in Script.

Use below line in Script.

if(Subfield(Feature,',',1)='Wifi',Subfield(Feature,',',1),'')    AS  FieldName.

If you want to give any value where no wifi value found in the field then add value in the else part of the if condition.

Hopefully this'll work.

[sasikanth]

Try this in Listbox expression:

=if(wildmatch(features,'*wifi*'),mobiles)

script:

LOAD * INLINE [

    mobiles, features

    i phone, 'wifi, bluetooth'

    blackberry, 'wifi, whatapp'

    moto, 'hotspot, 2gbram'

    micromax, 'wifi, facebook'

];