topic Re: Can I use a mapping table created inside a subroutine outside the subroutine? in QlikView

Can I use a mapping table created inside a subroutine outside the subroutine?

Anonymous — Fri, 06 Oct 2017 09:28:54 GMT

See the example below:

Sub Mappings

Codesmap:

Mapping LOAD * Inline [

Code, Description

01, Code 01

02, Code 02

03, Code 03

];

End Sub

Call Mappings;

Table1:

Load

Field1,

Applymap('Codesmap',Field1) as CodeDescription,

Field2,

Field3

FROM

[Stuff.xlsx]

(ooxml, embedded labels, table is StuffData);

Re: Can I use a mapping table created inside a subroutine outside the subroutine?

tomasz_tru — Tue, 10 Oct 2017 14:37:32 GMT

Do you have any problems with that script? It should be working.

Tomasz

Re: Can I use a mapping table created inside a subroutine outside the subroutine?

Anonymous — Tue, 10 Oct 2017 14:41:37 GMT

My script is more complex than the one I used as an example. Let me check my script again.

Thanks Tomasz.

Re: Can I use a mapping table created inside a subroutine outside the subroutine?

marcus_malinow — Tue, 10 Oct 2017 14:54:10 GMT

Hi Pablo,

QlikView has no real concept of scope, so yes, that would work just fine.

The only proviso, is that obviously you must create your mapping table prior to referencing it!

Marcus

Re: Can I use a mapping table created inside a subroutine outside the subroutine?

Peter_Cammaert — Tue, 10 Oct 2017 15:28:36 GMT

QlikView has no real concept of scope, ...

For tables and fields that may be true. But don't be mistaken: SUBs have a very strict concept of scope. And so do loops. All of them.

Re: Can I use a mapping table created inside a subroutine outside the subroutine?

Anonymous — Tue, 10 Oct 2017 16:36:10 GMT

Do you mean that a mapping table created in SUB cannot be used outside the SUB?

Re: Can I use a mapping table created inside a subroutine outside the subroutine?

marcus_malinow — Tue, 10 Oct 2017 16:36:55 GMT

I stand corrected! Thanks for the clarification Peter

Re: Can I use a mapping table created inside a subroutine outside the subroutine?

Anonymous — Wed, 11 Oct 2017 14:55:01 GMT

I've done this test:

Sub Mappings

Codesmap:

Mapping LOAD

Code, Description

FROM (ooxml, embedded labels, table is Sheet2);

End Sub

Call Mappings();

Table1:

LOAD

Field1,

Applymap('Codesmap',Field1, 'NO MAP') as CodeDescription,

Field2,

Field3

FROM (ooxml, embedded labels, table is Sheet1);

And it works without problems.

Thanks for your help