Load SQL Table Alias

[#1]

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?

[Oleg_Troyansky]

Cache,

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

MyTable:

LOAD...

[CELAMBARASAN]

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

[jagan · Accepted solution]

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.