topic Re: If statement in loadscript in QlikView

If statement in loadscript

francisvandergr — Mon, 10 Oct 2011 13:01:43 GMT

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 — Mon, 10 Oct 2011 13:08:39 GMT

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 — Mon, 10 Oct 2011 14:10:06 GMT

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