Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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?

1 Solution

Accepted Solutions
MVP
MVP

Load SQL Table Alias

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.

3 Replies

Load SQL Table Alias

Cache,

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

MyTable:

LOAD...

Load SQL Table Alias

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

MVP
MVP

Load SQL Table Alias

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.

Community Browser