topic Re: For a mapping table: Load only certain entries from a table in QlikView

For a mapping table: Load only certain entries from a table

Mon, 18 Nov 2013 13:58:15 GMT

Hi,

I would like to create a mapping table containing an ID and a Name field. I want the mapping table only to be filled for a special pattern in the name field:

'DExxxx', where the x's are numbers like 'DE1234'

Problem is, that the source contains enough different values like 'ENxxxx' or even names like 'Amacut' or 'Beedot'. How can I filter my pattern during load?

My current solution is LOAD if(wildmatch(NAME, 'AM*'), NAME) as Name

but this does include the 'Amacut' from my previous example and several others.

Thanks.

Re: For a mapping table: Load only certain entries from a table

Clever_Anjos — Mon, 18 Nov 2013 14:01:30 GMT

mapping load

ID,

NAME

from yoursource

where NAME like 'DE*'

Re: For a mapping table: Load only certain entries from a table

Mon, 18 Nov 2013 14:08:07 GMT

I''m sorry, I messed up my example. In addition to the regular 'DExxxx' that I want to have, there are entries like 'DEDFF' in the same field that I want to exclude. If i could work with regular expressions like in other languages I would check for four digits after the DE.

Re: For a mapping table: Load only certain entries from a table

Clever_Anjos — Mon, 18 Nov 2013 14:32:12 GMT

mapping load

ID,

NAME

from yoursource

where NAME like 'DE*' and len(keepchar(NAME,'0123456789'))>0 // check if there´s valid digits