How to create a table from a loaded table from DB ... - Qlik Community

Anonymous · ‎2016-08-08

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_TASKS; selecting 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.markham‌swuehl‌thp‌@

Mark_Little · ‎2016-08-08

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 · ‎2016-08-08

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