Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

shaimamahmoud
New Contributor III

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
mark6505
Valued Contributor III

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

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

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

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

Community Browser