1 Reply Latest reply: Apr 28, 2018 11:20 AM by Sumanta Kumar Mandal RSS

    Showing numbers in table with out dates

    Dipesh Vadgama

      Hi,

       

      I have a 2 different data set with out any unique id match with each other. 1 does have proper dates and other do not have dates but do have month in text format.

       

      Now I would like to see both info in single straight table.

      When I apply 1 set of data in table with its =month(date) and count is shows me 1st set of data, But when I also add 2 set data by it do not give any value. reason it do not have dates to match with 1set of data.

       

      I have attached sample data, hope is make more sense.

       

      I not sure how could I solve it, Please help me.

        • Re: Showing numbers in table with out dates
          Sumanta Kumar Mandal

          Hi Dipesh,

           

          Script:

          TAB1:

          LOAD

          'AUDIT' AS ORIGIN,

          Status,

          MONTH(Date) AS MONTH,

               [Audit Level],

               Location

          FROM

          [C:\Users\SumantaM\Desktop\Need help in straight table.xlsx]

          (ooxml, embedded labels, header is 1 lines, table is Sheet1)

          WHERE ROWNO()<7;

           

           

          CONCATENATE

          LOAD

          'LEARNING' AS ORIGIN,

          Status1 AS Status,

               Learning,

               Location1 AS Location,

               MONTH(DATE(DATE#(Month,'MMM'),'MMM')) AS MONTH

          FROM

          [C:\Users\SumantaM\Desktop\Need help in straight table.xlsx]

          (ooxml, embedded labels, header is 1 lines, table is Sheet1)

          WHERE ROWNO()<15;

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

          pic.PNG