2 Replies Latest reply on May 26, 2015 3:37 AM by Rajan Kumar

    Hi..I have two tabs in xl files.

    Rajan Kumar
      TIMESHEETHDRID
        • 1. Re: Hi..I have two tabs in xl files.
          Sankarmagesh Rajan

          hi Rajan,

          Do you want to join two tabs in tableau.

          please explain detail

           

          Thanks

          sankar

          • 2. Re: Hi..I have two tabs in xl files.
            Rajan Kumar

            I have two sheets n common column is

            TIMESHEETHDRID

            first sheet as

            TIMESHEETHDRID WEEKOF   DD1    DD2 DD3 DD4 DD5 DD6 DD7 DD8 DD9 DD10 DD11 DD12 DD13 DD14 WEEKEND (these are columns)

            16 12-09-2013 MO 09 TU 10 WE 11 TH 12 FR 13 SA 14 SU 15 MO 16 TU 17 WE 18 TH 19 FR 20 SA 21 SU 22 12-22-2013  (these r values)

             

            Second sheet:

             

            TIMESHEETHDRID MON TUE WED THU FRI SAT SUN MON2 TUE2 WED2 FRI2 SAT2 SUN2  (these r columns)

            16                                0 4 0 4 0 0 0 0 4 0 0 0 0     (values in hours)

             

            i want my result table contains like that..

             

            TIMESHEETHDRIDDateHours
            1612-09-20130
            1612-10-20134
            1612-11-20130
            1612-12-20134
            1612-13-20130
            1612-14-20130
            1612-15-20130
            1612-16-20130
            1612-17-20134
            1612-18-20130
            1612-19-20130
            1612-20-20130
            1612-21-20130
            1612-22-20130

             

            Actually i want to run a query in which user will give start date n end date n i want to find out consumed hrs.

            Problem is i have weekof n weekend columns but it is difference of 14.

            like as 12-09-2013 map to m0 09...how i have to do.....and m0 09 map to mon in another sheet. for getting hours values.

             

            thats why i think if i will get another sheet from two sheet using column timesheethdrid....

            Is it possible in tableau we will get individual date from two range and mapping is also right to correspoding column from both sheets.

             

            And can we use custom sql for mapping using case ....

             

            Please, help me.