topic Apply Map inside Apply Map in QlikView

Apply Map inside Apply Map

Fri, 03 Sep 2010 09:41:05 GMT

Hi,

is it possible to write a code like applymap('map1',applymap('map2',Field1)) ? (I tested it 5 time ago it seems working [:)])

if it is possible what is the maximum level of applymap inside applymap ?

Thanks.

Apply Map inside Apply Map

Miguel_Angel_Baeyens — Fri, 03 Sep 2010 09:47:31 GMT

Hello Kerem,

It's possible and very useful indeed. You already tried it so you know. I have been using ten nested applymaps with some thousands of records and it went fine. I don't know, though, whether there is some limitation to the command.

Regards.

Apply Map inside Apply Map

Fri, 03 Sep 2010 10:02:20 GMT

Thanks very much 🙂 I have 30 milyon records and four level applymaps.Thanks

Apply Map inside Apply Map

Mon, 31 Jan 2011 23:02:24 GMT

Hi friends,

can you make me an example?

I can't make it work

thanks

regards

Apply Map inside Apply Map

marcohadiyanto — Tue, 01 Feb 2011 08:39:30 GMT

hi all,

can i see the example?

i want to try but can't do it

thanks

Re: Apply Map inside Apply Map

Miguel_Angel_Baeyens — Thu, 03 Feb 2011 10:01:20 GMT

Hello Marco,

Kind of dummy example though:

EmployeeToCodeMap:

MAPPING LOAD * INLINE [

EmpID, EmpCode

A, 1000

B, 2000

C, 3000

];

NameToIDMap:

MAPPING LOAD * INLINE [

EmpName, EmpID

John, A

Peter, B

Mike, C

];

TableWithEmployeeNames: // Here I want the code for the employee

LOAD Name,

ApplyMap('NameToIDMap', Name, 'Without ID') AS ID, // This passes the employee name and returns the employee ID

ApplyMap('EmployeeToCodeMap', ApplyMap('NameToIDMap', Name, 'Without ID'), 'Without Code') AS Code, // Need the first applymap to get the ID, then the second to get the code

Address

FROM Emloyees.qvd (qvd); // Or whatever source

Hope that helps

Apply Map inside Apply Map

stevedark — Tue, 07 Jun 2011 22:32:19 GMT

Hi there,

Please take a look at this blog post for a discussion on the use of the ApplyMap statement:

http://bit.ly/kQcAZ5

Steve

Re: Apply Map inside Apply Map

ysj — Wed, 17 Jan 2018 09:12:57 GMT