2 Replies Latest reply: Nov 17, 2015 11:18 AM by Luca Jonathan Panetta RSS

    Custom dimension in Table column

    Kumar Pramod

      Hi all,

       

      How can i use the field of different tables as dimension in table.

      I need to have the first column of table as,

      delivered,

      opened,

      from EMAILMETRICS table.

       

      `landing_page_hits`,

          `sign_up`,

          completions from CAMPAIGNMETRICS  table.



      Header 1Header 2Header 3
      Delivered
      Opened
      landing_page_hits
      signup
      completions


      LOAD `campaign_metrics_id`,

          `email_type_id` as metrics_email_type_id,

          sent,

          delivered,

          bounced,

          opened,

          clicks,

          unsubscribes,

          deferred;

      SQL SELECT `campaign_metrics_id`,

          `email_type_id`,

          sent,

          delivered,

          bounced,

          opened,

          clicks,

          unsubscribes,

          deferred

      FROM EMAILMETRICS;

       

      LOAD `batch_meta_data_id`,

          `landing_page_hits`,

          `sign_up`,

          completions,

          fails,

          partials,

          num_required_subjects;

      SQL SELECT

         `batch_meta_data_id`,

          `landing_page_hits`,

          `sign_up`,

          completions,

          fails,

          partials,

          num_required_subjects

      FROM CAMPAIGNMETRICS ;

       

       

       

      Thanks,

      Kumar

        • Re: Custom dimension in Table column
          Simone Trabattoni

          Hi!

          Maybe you could try to use the CrossTable function with the Concatenate function.

          Here probably something helpful:

           

          The Crosstable Load

           

          The idea is to concatenate two different CrossTable

          Here a simple example:

           

          crosstable(header1,header2)

          load

          dim1,

          dim2,

          dim3,

          dim4,

          ....

          sql select

          ...

          FROM EMAILMETRICS

          group by

          ....;

           

          concatenate

           

          crosstable(header1,header2)

          load

          dim1,

          dim2,

          dim3,

          dim4,

          ....

          sql select

          ...

          FROM CAMPAIGNMETRICS

          group by

          ....;

          • Re: Custom dimension in Table column
            Luca Jonathan Panetta

            Hi Kumar,

             

            you can create a inline table

             

            NewTable:
            LOAD * INLINE [
                Header1, Header2, Header3
                delivered, ,
                opened, ,
                landing_page_hits, ,
                sign_up, ,
                completions, ,
            ];
            

             

            and if you want to user it in a Pivot table or other chart you can use Set Analysis to get related data.

             

            Best Regards

            Luca Jonathan Panetta