2 Replies Latest reply: Dec 3, 2012 12:18 PM by Jairaj Singh RSS

    How to group columns??

    Jairaj Singh

      I have data in following format:

       

      YearQuarterMonthWeekSchedule HrsWorked Hours Absent HoursOvertimePlannedHolidayVacationUnplannedSickJuryBereavementPlantDepartmentJobS1S2S3
      201011Week 0120019010206424121Flint Assembly01023-T-0DIE01011-1001424
      201011Week 02150131193810379252Flint Assembly01023-T-0DIE01011-1001838
      201011Week 0317513639762061419577Flint Assembly01023-T-0DIE01011-1001161112
      201011Week 0419017812237255113Flint Assembly01023-T-0DIE01011-1001624

       

      Now I want

      1) "Planned" and "Unplanned" comes under Leave.    for example:

      Leave
      Planned
      Unplanned

                      

        2) "Holiday" and "Vacation" comes under "Planned".

        3) "Sick", "Jury" and "Bereavement" comes under "Unplanned".

        4)"S1","S2" and "S3" comes under "Shift".

       

      How can I achieve this??

      This type of grouping I want in my .qvw file when I create list boxes I want Leave,Planned,Unplanned and Shift Fields.

        • Re: How to group columns??
          Gysbert Wassenaar

          You'll need to transform your data and create an extra field for the groups. See attached example.

            • Re: How to group columns??
              Jairaj Singh

              Hi Gysbert,

              Thanks for the solution.

              You make a Group which contains:

                                                      Group

                                                     ------------

                                                    Planned

                                                    Unplanned

                                                    Shift

                                                    Total

                                                    Work

               

              But I want 4 groups like

               

              Leave                      Planned                        Unplanned                              Shift                

              ------------                 ---------------                     -------------------                          ---------------

              Planned                  Holiday                           Sick                                       S1

              Unplanned              Vacation                          Jury                                       S2                                               

                                                                                   Bereavement                           S3

              Please help how I get this.???