If statement in loadscript

[francisvandergr]

I have the following situation. I have a field "City" in a Database. In my load script i want load the city in 1of 2 ways.

1. When city has a 'comma'  in the name Qlikview must read the field  till the 'comma'

2. When city has no 'comma' i wanna have the whole field.

How can i dot this with QV ? I hope someone can help

[its_anandrjs]

Hi,

Load your data some think like

Load

City,

Subfield(City, ' , ' , 1 )  as WithoutComaCity

From Data

It will exclude ' , ' from the City table

Rgds

Anand

[SunilChauhan · Accepted solution]

see the attched file

it is based on : instead of comma but you can change : with comma in your application.

and modify accoding to sample in ur application

please see the attached file

hope this help