topic Re: Data Quality Issue in QlikView

Data Quality Issue

Thu, 04 Feb 2016 19:03:20 GMT

I have this data quality issue and I have attched the sample QVW (With my requirement as comments and the Excel file.Please help me here.

Thanks much

Anonymous — Thu, 04 Feb 2016 19:20:17 GMT

You could use the Index() command to check whether LeaseCode has an underscore in it and set the AreaCode to Null() if it does not.

Leas:

LOAD

Code as LeaseCode,

// right([Code],4) as AreaCode,

if ( index ( Code ,'_' ) > 0 , right(

,4) , null() ) as AreaCode,

Key as Buildgkey

FROM

Sample.xlsx

(ooxml, embedded labels, table is Leas);

Thu, 04 Feb 2016 19:31:14 GMT

Thank you Bill Markham that worked , meanwhile I tried wildmatch

if(wildmatch([Code],'*_*'), right([Code],4)) as [ Area Code],

and that worked too

Thank you and appreciate your help.

Anonymous — Thu, 04 Feb 2016 19:34:18 GMT

Glad you are ok now.

Wildmatch() would do the same, just a few more keystrokes to type and I am a lazy typer.