Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

alexantone
Contributor

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

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

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
Contributor

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

Hello Sunny , thank for your return,

In fact with this solution we lose the OLEDB Connection

Alex

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

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

alexantone
Contributor

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

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

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

Would you be able to share your script?

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

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
Contributor

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

I retry now and it's ok !

thank sunny & Colin

dimitri_obrant
Contributor

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

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

oknotsen
Honored Contributor III

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

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!