topic Re: Re: Problem with syntax in resident load in QlikView

Problem with syntax in resident load

Anonymous — Mon, 11 Nov 2013 11:34:21 GMT

Hi all,

I have a problem with the syntax in the given data.

I want to make a resident load with a where-statement, but the syntax leads to a wrong result:

Liste1:

Load *

Resident Testliste

where wildmatch(Projektbaum,''Car / Bike'); //"Car / Bike" = should be like one word

Liste2:

Load *

Resident Testliste

where wildmatch(Projektbaum,''Haus / Baum'); //"Haus / Baum" = should be like one word

The / leads to a problem as there are wrong results for both lists=> I can't change the syntax as it is needed later in this way.

Do you have any idea how to solve that problem?

Thank you very much!

Re: Problem with syntax in resident load

kaushiknsolanki — Mon, 11 Nov 2013 11:41:50 GMT

Hi,

It seems that you are using double quote, try single quote in Wildmatch function.

And one more thing to notice here that you should either use the "noconcatenate" keyword before second table loading, the reason is both the table will have same fields and thus QlikView will concatenate them by default.

Regards,

Kaushik Solanki

Re: Problem with syntax in resident load

swuehl — Mon, 11 Nov 2013 11:43:53 GMT

Are you mixing two singles quote at the beginning of the strings to match with one single quote at the end?

I think you should use single quote only. If you don't use wildcards, you can use the match function.

I can't currently see a problem with the slash '/', but maybe I am missing something. Could you upload some sample lines of input data?

Re: Problem with syntax in resident load

Mon, 11 Nov 2013 11:57:16 GMT

try this..

Load *

Resident Testliste

where wildmatch(Projektbaum,'Car','Bike');

Re: Problem with syntax in resident load

Anonymous — Mon, 11 Nov 2013 12:17:20 GMT

Hi Kaushik Solanki,

thank you for your anwser, but in my skript i am using single quote and noconcatenate.

There are a lot of Test-Lists in which I use resident load in combination with where.

The only problem is with the the writing of two statements with /

Re: Problem with syntax in resident load

kaushiknsolanki — Mon, 11 Nov 2013 12:19:14 GMT

Hi,

try this.

wildmatch(Projektbaum,'*Car*/*Bike*');

Regards,

Kaushik Solanki

Re: Problem with syntax in resident load

Anonymous — Mon, 11 Nov 2013 12:19:45 GMT

Hi,

thank you fpr your answer!

I am using single quotations! The skript is really long so that I can't upload it. But I made several tests and I only get the problem with /

Thanks for your help!

Re: Problem with syntax in resident load

Anonymous — Mon, 11 Nov 2013 12:30:59 GMT

... it also didn't work

Re: Problem with syntax in resident load

kaushiknsolanki — Mon, 11 Nov 2013 12:33:00 GMT

Kindly Post your script.

Regards,

Kaushik Solanki

Re: Re: Problem with syntax in resident load

swuehl — Mon, 11 Nov 2013 12:45:22 GMT

Ok, but it's really hard to reproduce your issue without knowing your setting. Just telling 'it does not work' is not helping very much. It would be best if you prepare a small sample application that demonstrates your issue and post it to this thread.

I've attached a sample, seems to work ok for me.

Re: Problem with syntax in resident load

Anonymous — Mon, 11 Nov 2013 14:42:16 GMT

Thank you for all your help:

The problem was that there were 2 mistakes:

1) in one sentence I didn't use single quote

2) there was an doubled sentenced with both (Car/Bike and Baum/Haus) in the given data => had to correct the delivering system.

Now is works => Thank you so much!