Make a normally loaded Excel_table into a mapping table?

[datanibbler]

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

[Anonymous]

Could you share the script ?

[marcus_sommer]

Hi DataNibbler,

how looks the complete mapping-statement?

- Marcus

[avinashelite]

please post the script

[datanibbler]

Hi,

the final mapping statement is

MAPPING LOAD

Map_Einsatzbereiche:

LOAD

     Bereich,

     Staplernrn

RESIDENT Liste_Einsatzbereiche;

[marcus_sommer]

Try it so:

Map_Einsatzbereiche:

Mapping LOAD

     Bereich,

     Staplernrn

RESIDENT Liste_Einsatzbereiche;

[#7 · Accepted solution]

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]

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