Script prob

[nikhilgarg]

Hey,

My script is:

Load CityId,

Cityname

CountryCode

from abc.qvd ;

i want to apply condn where Country Code = US and CA

I applied like:

Load CityId,

Cityname

CountryCode

from abc.qvd  where CountryCode = {'US' , 'CA'} ;  but giving error.

[tresesco · Accepted solution]

Try like:

Load CityId,

Cityname,

CountryCode

from abc.qvd  where Match(CountryCode, 'US' , 'CA') ;

Edit: Corrected a comma.

[sushil353]

Hi,

Try this:

Load CityId,

Cityname

CountryCode

from abc.qvd  where Match(CountryCode ,'US' , 'CA') ;

[sunilkumarqv]

try this

Load CityId,

Cityname,

CountryCode

from abc.qvd  where CountryCode='US' and CountryCode='CA';

OR

Load CityId,

Cityname,

CountryCode

from abc.qvd  where Match(CountryCode,'US' ,'CA');

[ashwanin]

Use Where Match (CountryCode,'US','CA') ;

[qlikviewwizard]

Hi

Use like this:

LOAD CITYID,

CITYNAME,

COUNTRYCODE

FROM ABC.QVD  WHERE MATCH(COUNTRYCODE,'US' ,'CA');

[nikhilgarg]

Hey,

I have used like:

Table1:

Load CityId,

Cityname,

CountryCode

from abc.qvd ;

Table2:

Load * resident Table1 where CountryCode = Match(CountryCode, 'US', 'CA') ;

Is this also ryt ?

[nikhilgarg]

Hey,

I have used like:

Table1:

Load CityId,

Cityname,

CountryCode

from abc.qvd ;

Table2:

Load * resident Table1 where CountryCode = Match(CountryCode, 'US', 'CA') ;

Is this also ryt ?

[nikhilgarg]

Hey,

I have used like:

Table1:

Load CityId,

Cityname,

CountryCode

from abc.qvd ;

Table2:

Load * resident Table1 where CountryCode = Match(CountryCode, 'US', 'CA') ;

Is this also ryt ?

[qlikviewwizard]

Hi,

Can you upload your file?

Thank you.