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.

datanibbler
Not applicable

Make a normally loaded Excel_table into a mapping table?


Hi,

I have loaded an Excel table that should have just 2 columns. There were a few more, so I processed the table a bit

and now I actually have an ideal mapping table with 2 columns.

When I try to do a MAPPING LOAD ... RESIDENT, however, I get the error message "unallowed combination of commands".

Can anyone tell me how I have to do this?

Thanks a lot!

Best regards,

DataNibbler

1 Solution

Accepted Solutions
Not applicable

Re: Make a normally loaded Excel_table into a mapping table?

The syntax is a bit wrong that's all, you have load twice

Map_Einsatzbereiche:

MAPPING LOAD

     Bereich,

     Staplernrn

RESIDENT Liste_Einsatzbereiche;

should work fine

hope that helps

Joe

7 Replies
bill_markham
Not applicable

Re: Make a normally loaded Excel_table into a mapping table?

Could you share the script ?

marcus_sommer
Not applicable

Re: Make a normally loaded Excel_table into a mapping table?

Hi DataNibbler,

how looks the complete mapping-statement?

- Marcus

avinashelite
Not applicable

Re: Make a normally loaded Excel_table into a mapping table?

please post the script

datanibbler
Not applicable

Re: Make a normally loaded Excel_table into a mapping table?

Hi,

the final mapping statement is

MAPPING LOAD

Map_Einsatzbereiche:

LOAD

     Bereich,

     Staplernrn

RESIDENT Liste_Einsatzbereiche;

marcus_sommer
Not applicable

Re: Make a normally loaded Excel_table into a mapping table?

Try it so:

Map_Einsatzbereiche:

Mapping LOAD

     Bereich,

     Staplernrn

RESIDENT Liste_Einsatzbereiche;

Not applicable

Re: Make a normally loaded Excel_table into a mapping table?

The syntax is a bit wrong that's all, you have load twice

Map_Einsatzbereiche:

MAPPING LOAD

     Bereich,

     Staplernrn

RESIDENT Liste_Einsatzbereiche;

should work fine

hope that helps

Joe

datanibbler
Not applicable

Re: Make a normally loaded Excel_table into a mapping table?

Thanks!  

I am not quite sure why - my syntax was right, I mis-typed it here because I often experienced problems when copying from a script, so I don't do that and I got it wrong - but it works now. That's all that is required.

Thanks a lot!

Best regards,

DataNibbler