Applymap don't work!!

[#1]

Hi every one

I have made a mapping tabel:

Map:

Mapping  LOAD Bron1,

     Bron2

FROM

(biff, embedded labels, table is Sheet1$);

and the follow table with the applymap;

Tabel:

LOAD date(Date#( date ,'YYYYMMDD'),'DD-MM-YYYY') as date,

    sourceMedium as verkeersbron,

    sessions as sessies,

    applymap('Map',bron1) as Bron2

FROM [http://research.ilsemedia.nl/query-tool/app/viewcustomreport.php?report=477&format=xml] (XmlSimple, Table is [data/query0/row]);

But it dont work someone suggestions?

@

[sunny_talwar]

I think you need to replace bron1 with the field in your current Tabel (either sourceMedium or sessions).

Tabel:

LOAD date(Date#( date ,'YYYYMMDD'),'DD-MM-YYYY') as date,

    sourceMedium as verkeersbron,

    sessions as sessies,

    applymap('Map',bron1) as Bron2

FROM [http://research.ilsemedia.nl/query-tool/app/viewcustomreport.php?report=477&format=xml] (XmlSimple, Table is [data/query0/row]);

Look QlikView's help for an example: QlikView ‒ ApplyMap - script function

[#3]

Hi sunny

how do you mean

[MindaugasBacius]

Applymap(<map that you have created>, <the field name that is in the table where you what to use Applymap function>)

[sunny_talwar]

I am assuming you don't have bron1 in your data coming from the XML file, right? You need to use a field which is equivalent of bron1 in your XML file. We don't use the field name from Mapping Table load here.

[#6]

But  i have tried also source medium but it dont works

[#7]

Tabel:

LOAD date(Date#( date ,'YYYYMMDD'),'DD-MM-YYYY') as date,

    sourceMedium as verkeersbron,

    sessions as sessies,

    applymap('Map',verkeersbron) as Bron2

FROM [http://research.ilsemedia.nl/query-tool/app/viewcustomreport.php?report=477&format=xml] (XmlSimple, Table is [data/query0/row]);

[sunny_talwar]

Try this:

Tabel:

LOAD date(Date#( date ,'YYYYMMDD'),'DD-MM-YYYY') as date,

    sourceMedium as verkeersbron,

    sessions as sessies,

    applymap('Map',sourceMedium) as Bron2

FROM [http://research.ilsemedia.nl/query-tool/app/viewcustomreport.php?report=477&format=xml] (XmlSimple, Table is [data/query0/row]);

[#9]

Ok, i gonna trie it

I wanna match sourcemedium with bron 2

[#10]

Sunny

Great !!

It works thanks for your hulp!!