1 Reply Latest reply: Dec 6, 2012 2:50 AM by Or Shoham RSS

    Break the link during data loading for same field

      Hello Expert,

       

      Loading data from one file and want to generate multiple field against same field, the result value set is OK but the duplications values appear in list. For example:

       

      DateSales
      2012/12/05500
      2012/12/06600
      2012/12/07700
      2012/12/08800

       

      Load command as

       

      LOAD Date,

                Date(Date, 'YYYY') as Year,

                 Date(Date, 'WWWW') as Day,

                Sales

      FROM File.

       

      Result

      DateYearDaySales
      2012/12/052012Wed500
      2012/12/062012Thur600
      2012/12/072012Fri700
      2012/12/082012Sat800

       

      In Fields Displayed in Listboxs select all.

       

      The expected Listbox value for 'Year' is only one value '2012'. However, the actual is 4 single value(2012) in the list box. Apparently the year is sticking to original value set. Is there any way to break the link?

       

      Many thanks!

      HTC