Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
Cache,
you can label the table by specifying the name with a colon ":" before the load:
MyTable:
LOAD...
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
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.