3 Replies Latest reply: May 12, 2010 3:53 PM by Dinesh Thoniparambil RSS

    Duplicate column in LOAD

      I have a date column in a pipe delimited text file. I created an expression year(date) and displayed the year in a list box. I created another list box having value month(date). Since the 2 list-box are derived from the same field, I cannot do a logical drill. Say I select year 2010, & then withing 2010, I want to select Jan. When I select Jan, it de-selects the year 2010 & shows all years which has Jan as a valid column.

      I think Qlickview is filtering at the field lever & not at the expression level. One solution is to duplicate the field at the LOAD level. How can I duplicate that in the LOAD statement? Any other solutions?

      Thanks,

      Dinesh.