Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi, just to comunicate that I solve the issue.
I found a post of "Swuehl" that help me on the issue.
Thanks to the comunitity for the help
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!
add an
order by OrderNumber
in the resident load
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.
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;
Hi, just to comunicate that I solve the issue.
I found a post of "Swuehl" that help me on the issue.
Thanks to the comunitity for the help