Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
@
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
Hi sunny
how do you mean
Applymap(<map that you have created>, <the field name that is in the table where you what to use Applymap function>)
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.
But i have tried also source medium but it dont works
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]);
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]);
Ok, i gonna trie it
I wanna match sourcemedium with bron 2
Sunny
Great !!
It works thanks for your hulp!!