Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
alexantone
Creator
Creator

Mappind load from a table (in one and only step)

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);

12 Replies
sunny_talwar

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

alexantone
Creator
Creator
Author

Hello Sunny , thank for your return,

In fact with this solution we lose the OLEDB Connection

Alex

sunny_talwar

So you mean the solution worked or did it not? Is losing OLEDB a good thing?

alexantone
Creator
Creator
Author

Hello sunny no didn't work , the connection with my database is lost

sunny_talwar

Would you be able to share your script?

Colin-Albert

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`;

alexantone
Creator
Creator
Author

I retry now and it's ok !

thank sunny & Colin

Anonymous
Not applicable

What about sql solution? You could create the mapping table in sql and join the table in sql view.

oknotsen
Master III
Master III

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.

May you live in interesting times!