Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello community
Is there an another way to do it without makes two steps
OLEDB CONNECT32 TO ...
TableMapping1:
load
xxxxx&'@'&yyyyyy&'@'&zzzzzz as MY_KEY,
myfield ;
sql select *
FROM `Table`;
STORE 'TableMapping1' INTO [$(DataPath)TableMapping1.qvd] (QVD);
MapContrat1:
Mapping load
MY_KEY,
NOUV_CONTR
from [$(DataPath)TableMapping1.qvd]
(qvd);
May be this:
TableMapping1:
MAPPING
LOAD xxxxx&'@'&yyyyyy&'@'&zzzzzz as MY_KEY,
myfield ;
SQL Select *
FROM `Table`;
and then use it in your applymap the same way as your would do in the above scenario
Hello Sunny , thank for your return,
In fact with this solution we lose the OLEDB Connection
Alex
So you mean the solution worked or did it not? Is losing OLEDB a good thing?
Hello sunny no didn't work , the connection with my database is lost
Would you be able to share your script?
You still need the oledb connection, just add the connect line above the load line.
oledb connect .......
TableMapping1:
MAPPING
LOAD xxxxx&'@'&yyyyyy&'@'&zzzzzz as MY_KEY,
myfield ;
SQL Select *
FROM `Table`;
I retry now and it's ok !
thank sunny & Colin
What about sql solution? You could create the mapping table in sql and join the table in sql view.
Doing it in SQL means doing it on the source system. In other words: Wasting the source systems time for something that can easily be done in QlikView. Plus usually it is faster on your QlikView server.