Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

jumiprado
New Contributor III

Create a new field

Hey guys i need your help for create a new field in my table.

I have this table and the action to do in the column TO DO


     

%ID%secDATE_FROMDATE_TOTYPEFilterTO DO
263414603427/02/2015Aonly one A
263414603327/02/2015A-take min (DATE_FROM) for same %ID and same %sec
263414603329/02/2016 Amultiple Adelete row
263414602629/12/2014A
263414603001/03/2015A
263414602329/12/2014A take date_to from TYPE C and delete row with type C
263414602329/02/2016 C delete row

     


I need to create a new table like this

  

%ID%secDATE_FROMDATE_TO
263414603427/02/2015today ()
263414603327/02/2015today ()
263414602629/12/2014today()
263414603001/03/2015today()
263414602329/12/201429/02/2016

Thanks!

Community Browser