topic Data Spillovers in QlikView

Data Spillovers

Anonymous — Mon, 11 May 2015 13:12:33 GMT

Hi,

I am importing a large dataset that has spillover issues, e.g. the field CITY has some numerical values, garbage values etc. Now is there way I can keep these CITY values as blanks? I don't want to skip all the fields, just to make the CITY as blanks where it finds numbers or special characters like #, &*

Thanks

Re: Data Spillovers

sujeetsingh — Mon, 11 May 2015 13:14:27 GMT

Wildmatch can help you.

Re: Data Spillovers

sunilkumarqv — Mon, 11 May 2015 13:18:26 GMT

try like this

Data:

LOAD PurgeChar(City,'@*#') as City;

LOAD * Inline

[

City

Chennai

Chennai#

Hyd@

Bangalore*

];

Re: Data Spillovers

Ralf-Narfeldt — Mon, 11 May 2015 13:26:22 GMT

This will replace bad values in CITY, the ones containing a character listed in the FindOneOf second argument, with an empty string to a field called CleanCity.

LOAD If(FindOneOf(City,'0123456789*!"#¤%&/'),City, '') As CleanCity;

You can of course add more characters to screen for.

Re: Data Spillovers

Anonymous — Tue, 12 May 2015 12:50:19 GMT

Thanks guys, appreciate the help

Re: Data Spillovers

Ralf-Narfeldt — Tue, 12 May 2015 12:52:14 GMT

Great! Please mark answers as Helpful or Answered!