Issue with one statement in 3 odbc connection tables

[#1]

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

[oknotsen]

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!

[maxgro]

add an

order by OrderNumber

in the resident load

[#4]

Hi

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.

[#5]

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;

[#6 · Accepted solution]

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