4 Replies Latest reply: Jun 16, 2016 7:29 AM by Nicolas MARTIN RSS

    How to have numeric values in a cross table?

    Nicolas MARTIN

      Hello,

       

      I want to load the crosstable

      2016-06-16_120759.jpg

       

       

      I have the following script:

       

      Source:

      LOAD * INLINE [

      MyField, 2010, 2011, 2012

      Test, x, y, z

      Test2, xx, yy, zz

      ];

       

       

       

      Cross:

      CrossTable(Year, Value)

      LOAD

        MyField,

        [2010],

        [2011],

        [2012]

      RESIDENT Source;

       

       

       

      ForceNum:

      LOAD

        num(Year) AS Forced.Year,

        Year AS Forced.Year_origin,

        MyField AS Forced.MyField,

        Value AS Forced.Value

      Resident Cross;

       

       

      I can't success to have the "Year" filed as a numeric value.

      Even the "num(Year)" returns nothing.

       

      2016-06-16_120914.jpg

       

      Why?

       

      How can I have my Year field as a numeric value?