topic Re: Applymap with dynamic table name in App Development

Applymap with dynamic table name

micheledenardi — Thu, 03 Aug 2017 12:35:55 GMT

Hi guys,

is there a way to use a field (in my case "Dim3" ) as teble name during an applymap() ?

I know that the table name must be enclosed by single quote but there is anybody which know any trick ?

I want to avoid join or concatenate solutions...

Dim1	Dim2	Dim3	Value1
A	AA	MappingTable1	1
B	BB	MappingTable2	2
C	CC	MappingTable3	3
D	DD	MappingTable4	4
E	EE	MappingTable5	5
F	FF	MappingTable6	6

Re: Applymap with dynamic table name

sunny_talwar — Thu, 03 Aug 2017 12:45:18 GMT

Do you have a sample where we can test this out?

Re: Applymap with dynamic table name

jmvilaplanap — Thu, 03 Aug 2017 12:49:44 GMT

You can define the table name as a variable with LET LET and SET

But I need a sample to see exactly what are you thinking to do.

Regards

Re: Applymap with dynamic table name

micheledenardi — Thu, 03 Aug 2017 12:52:51 GMT

I've attached the sample data

Re: Applymap with dynamic table name

sunny_talwar — Thu, 03 Aug 2017 13:13:12 GMT

I guess not what you would like, but your best bet is this

FactTable:

LOAD Dim1,

Dim2,

Dim3,

Value1,

Pick(KeepChar(Dim2, '0123456789'),

ApplyMap('MappingTable1', Dim2),

ApplyMap('MappingTable2', Dim2),

ApplyMap('MappingTable3', Dim2),

ApplyMap('MappingTable4', Dim2),

ApplyMap('MappingTable5', Dim2),

ApplyMap('MappingTable6', Dim2)) as MappedValue2

FROM

[..\..\Downloads\SampleData.xlsx]

(ooxml, embedded labels, table is Foglio1);

Re: Applymap with dynamic table name

micheledenardi — Thu, 03 Aug 2017 13:26:16 GMT

Hi Sunny,

thanks for you solution but i want to avoid fixed table name.

I have found this thread Qlik Tips: Dynamic ApplyMap but this approach do not work for me... i've tried in both qlikview and qliksense but when the script execution arrive at the applymap qlik is freezing.