12 Replies Latest reply: Feb 8, 2016 7:17 AM by Sunny Talwar RSS

    Applymap don't work!!

      Hi every one

       

      I have made a mapping tabel:

      Map:

      Mapping  LOAD Bron1,

           Bron2

      FROM

      [C:\Users\k.talhaoui\Desktop\New B2.xls]

      (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?

      @