2 Replies Latest reply: Aug 8, 2016 10:52 AM by Bill Markham RSS

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

    Shaima Mahmoud

      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@