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.

Not applicable

Mapping load - how to see the table?

Hi everyone,

When we create a mapping load table, is there a way to see that table in the table viewer (or somewhere else)?

1 Solution

Accepted Solutions
sunny_talwar
Not applicable

Re: Mapping load - how to see the table?

You can create another table if you want to keep it.... May be like this

Table:

LOAD Column1,

          Column2,

          Column3

FROM XYZ....;

MappingTable:

Mapping

LOAD *

Resident Table;

3 Replies
trdandamudi
Not applicable

Re: Mapping load - how to see the table?

No, you will not see the mapping table in the Table viewer, If you want to see it then remove the the word 'Mapping' before the load statement and take a look. Hope this helps...

sunny_talwar
Not applicable

Re: Mapping load - how to see the table?

You can create another table if you want to keep it.... May be like this

Table:

LOAD Column1,

          Column2,

          Column3

FROM XYZ....;

MappingTable:

Mapping

LOAD *

Resident Table;

alexpanjhc
Not applicable

Re: Mapping load - how to see the table?

You can create the same table without using mapping load. You just need to be careful that it may change your data model, and you will see some unexpected results.