topic Re: Issue with one statement in 3 odbc connection tables in QlikView

Issue with one statement in 3 odbc connection tables

Fri, 10 Apr 2015 13:42:33 GMT

I have a table created from 3 odbc connection.

odbc from arteciarsu, groningen and vantaa jeeves

the have the same data structure , i insert a calculated variable but it not work in 2 or 3 case, ie for tables that come from groningen and vantaa.

please to see the attachement

Re: Issue with one statement in 3 odbc connection tables

oknotsen — Fri, 10 Apr 2015 16:33:02 GMT

Are you sure the attached document is the right document as it contains a LOT of code and screenshots. It also seems to contains multiple questions.

Please just put the related / relevant code and/or screenshots into this topic instead of adding a Word doc with "everything you can find". That saves us guessing what you actually want to discuss / ask. Thank you and have a nice weekend!

Re: Issue with one statement in 3 odbc connection tables

maxgro — Fri, 10 Apr 2015 19:06:23 GMT

add an

order by OrderNumber

in the resident load

Re: Issue with one statement in 3 odbc connection tables

Mon, 13 Apr 2015 05:34:18 GMT

thank for your reply. I insert the screen shots to explain what my currently script delivery to me.I insert the script to show you what I am doing, I just ask if my issue is due to a wrong script for the wrong way to merge the 2 db or something else.

Sorry if it created mess to you.

Re: Issue with one statement in 3 odbc connection tables

Mon, 13 Apr 2015 05:46:58 GMT

Hi,

i tried to insert your suggestion in the code, but i had the attached error:

Groningen:

LOAD *,week(Date) as Week, if(OrderNumber = peek(OrderNumber),0,1) as CountOrder order by OrderNumber,if(match(AlsisScope, 'J') or match(AlsisScope, 'G') , 'Yes', 'No') as PotentialIECom,TransfertPrice*Quantity as TransferPriceOrderQTY,'Groningen' as Supplyer

RESIDENT Temp;

Re: Issue with one statement in 3 odbc connection tables

Wed, 15 Apr 2015 08:19:03 GMT

Hi, just to comunicate that I solve the issue.

I found a post of "Swuehl" that help me on the issue.

Peek & Order by

Thanks to the comunitity for the help