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?
@
Not a problem. Please close the thread by marking correct and helpful answers if you got what you were looking for.
Best,
Sunny