topic Load SQL Table Alias in QlikView

Load SQL Table Alias

Thu, 26 Jan 2012 21:44:14 GMT

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 — Fri, 27 Jan 2012 00:07:09 GMT

Cache,

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

MyTable:

LOAD...

Load SQL Table Alias

CELAMBARASAN — Fri, 27 Jan 2012 05:01:53 GMT

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 — Fri, 27 Jan 2012 06:06:27 GMT

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.