1 Reply Latest reply: Oct 13, 2014 1:52 PM by Massimo Grossi RSS

    Join betwwen two crosstable

    safa guedria

      Hello,

       

      I created two cross table DataStock and DataArrival and I want to create one only  table which is the jointure between them.

      But I have an error: "Combination of prefixes prohibited"

       

      DataStock:

      CrossTable(Items , DataStock)

      LOAD F1 as DateStock,

        ....

      FROM

      [Data\Excel\MNPAF Délais hebdo 2014 v2.xlsx];

      join (DataStock)

      CrossTable(Items, DataArrivee)

      LOAD F1 as DateArrivee,

           ...

      FROM

      [Data\Excel\MNPAF Délais hebdo 2014 v2.xlsx];

       

       

      Thank you