1 Reply Latest reply: Mar 11, 2012 9:15 PM by Erich Shiino RSS

    Script problem

      How to Map the 2 dates column to one column of the master calendar??????

       

      How to assgn the aggregated value of the column to the variable???????

        • Script problem
          Erich Shiino

          Hi, Manish05

          You can read your original table twice renaming the different date fields to the same date that you are going to use on your master calendar. Then, you can add a flag to identify each one of your original dates.

           

          In the example below I combined Date1 and Date2 in the same field Date and used FactType as a flag I can use latter on in set analys or as a selection field.

           

           

           

          Original:

          Load Date1, Value, Date2

          from DataSource;

           

          Fact:

          Load Date1 as Date,

          '1' as FactType,

          Value

          Resident Original;

           

          Concatenate(Fact)

          Load Date2 as Date,

          '2' as FactType,

          Value

          Resident Original;

           

          drop table Original;

           

           

          Hope this helps,

           

          Erich