Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to create a table from a loaded table from DB Conenction

Hi Dears,

I have an ODBC postgres data connection to load data from .

I  have written some scripts to load this data in the 'Data load editor'

    this data after load has new table name and this table has new Structure.

as follows

[PROJECT_TASKS]:

SELECT id  As TSK_Id,

      name  AS TSK_Name,

      description  AS TSK_Description,

      planned_starttime  AS TSK_PlannedStartTime,

      actual_starttime  AS TSK_ActualStartTime,

      planned_endtime  AS TSK_PlannedEndTime,

      actual_endtime  AS TSK_ActualEndTime,

      resource_id  AS TSK_ResourceId,

      project_id AS TSK_ProjectId

FROM public.dsh_project_tasks_view;


Now after load data in local PROJECT_TASKS table ,

I want to make another select statement or load statement to select data from PROJECT_TASKS table to load another table with a new structure to make a new visualization with it.  can I ?????


like this , for example


[Task_Status]

select Tsk_Id as Tsk_status_id,

name as Tsk_status_name,

case when planned_endtime >= actual_endtime  then 'Ontime' else 'late' end as tsk_status,

from PROJECT_TASKSselecting from the previously loaded table up there 


please help me with a load statement or another select statement example as I don't know the syntax or If I can do this or not  ????!!!!

bill.markhamswuehlthp‌@

2 Replies
Mark_Little
Luminary
Luminary

Hi

Instead of from you want resident.

depending what you are wanting you may want to add the no concatenate function

so

Load

     *

Resident [Task_Status]

Where .....;

Mark

Anonymous
Not applicable
Author

You could use a preceding load and your extra field will be added to your table in an efficient way.

[PROJECT_TASKS]:

Load

    if ( TSK_PlannedEndTime >= TSK_ActualEndTime, 'Ontime' ,'late' ) as tsk_status,

    *

;

SELECT id  As TSK_Id,

      name  AS TSK_Name,

      description  AS TSK_Description,

      planned_starttime  AS TSK_PlannedStartTime,

      actual_starttime  AS TSK_ActualStartTime,

      planned_endtime  AS TSK_PlannedEndTime,

      actual_endtime  AS TSK_ActualEndTime,

      resource_id  AS TSK_ResourceId,

      project_id AS TSK_ProjectId

FROM public.dsh_project_tasks_view;

See this Blog by Henric explaining the Preceding Load