topic Re: Make a normally loaded Excel_table into a mapping table? in QlikView

Make a normally loaded Excel_table into a mapping table?

datanibbler — Thu, 05 Feb 2015 10:06:41 GMT

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

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

Anonymous — Thu, 05 Feb 2015 10:09:20 GMT

Could you share the script ?

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

marcus_sommer — Thu, 05 Feb 2015 10:09:28 GMT

Hi DataNibbler,

how looks the complete mapping-statement?

- Marcus

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

avinashelite — Thu, 05 Feb 2015 10:11:44 GMT

please post the script

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

datanibbler — Thu, 05 Feb 2015 10:12:40 GMT

Hi,

the final mapping statement is

MAPPING LOAD

Map_Einsatzbereiche:

LOAD

Bereich,

Staplernrn

RESIDENT Liste_Einsatzbereiche;

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

marcus_sommer — Thu, 05 Feb 2015 10:13:52 GMT

Try it so:

Map_Einsatzbereiche:

Mapping LOAD

Bereich,

Staplernrn

RESIDENT Liste_Einsatzbereiche;

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

Thu, 05 Feb 2015 10:14:56 GMT

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

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

datanibbler — Thu, 05 Feb 2015 10:18:46 GMT

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