3 Replies Latest reply: Jan 27, 2012 1:06 AM by jagan mohan rao appala RSS

    Load SQL Table Alias

      SQL SELECT `date` as lead_submitted_date,

          `date_id` as lead_submitted_date_id,

          `date_id` as relative_date_id,

          `day_long` as lead_submitted_day_long,

          `day_of_month` as lead_submitted_day_of_month,

          `day_of_week` as lead_submitted_day_of_week,

          `day_of_year` as lead_submitted_day_of_year,

          `day_short` as lead_submitted_day_short,

          `month_short` as lead_submitted_month_short,

          `month_year` as lead_submitted_month_year

      FROM cdwdb.`edw_dates_d` as lead_submitted_dates;

       

       

      I have this in my load script and I want the table edw_dates_d to be lead_submitted_dates once loaded.  But it shows up like this 

      http://screencast.com/t/MH4FKHsR.   How can I change that table name in QV?

        • Load SQL Table Alias
          Oleg Troyansky

          Cache,

           

          you can label the table by specifying the name with a colon ":" before the load:

           

          MyTable:

          LOAD...

          • Load SQL Table Alias
            Celambarasan Adhimulam

            Hi,

                 Use like this..

                

            lead_submitted_dates://Table name

            SQL SELECT `date` as lead_submitted_date,

                `date_id` as lead_submitted_date_id,

                `date_id` as relative_date_id,

                `day_long` as lead_submitted_day_long,

                `day_of_month` as lead_submitted_day_of_month,

                `day_of_week` as lead_submitted_day_of_week,

                `day_of_year` as lead_submitted_day_of_year,

                `day_short` as lead_submitted_day_short,

                `month_short` as lead_submitted_month_short,

                `month_year` as lead_submitted_month_year

            FROM cdwdb.`edw_dates_d`

             

            Celambarasan

            • Load SQL Table Alias
              jagan mohan rao appala

              Hi,

               

              Define table name on top of the Query followed by a colon

               

              lead_submitted_dates:

              SQL SELECT `date` as lead_submitted_date,

                  `date_id` as lead_submitted_date_id,

                  `date_id` as relative_date_id,

                  `day_long` as lead_submitted_day_long,

                  `day_of_month` as lead_submitted_day_of_month,

                  `day_of_week` as lead_submitted_day_of_week,

                  `day_of_year` as lead_submitted_day_of_year,

                  `day_short` as lead_submitted_day_short,

                  `month_short` as lead_submitted_month_short,

                  `month_year` as lead_submitted_month_year

              FROM cdwdb.`edw_dates_d`;

               

              Regards,

              Jagan.