topic Creating new columns with new reload in QlikView https://community.qlik.com/t5/QlikView/Creating-new-columns-with-new-reload/m-p/513547#M685622 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a QVD which has two column as 'Name' and 'Place' with value as:</P><P>Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Place</P><P>Pranav&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; India</P><P>Peter&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; America</P><P></P><P>I want to give another column in this as ADD-Time means.</P><P>If tomorrow when my QV app refreshes and checks with old qvd that my Column value Pranav is not in new refresh then in new column as TERM-Time give value as Current date.</P><P>And if a new Name has came Which was not in previous load example as Danny then in new column as ADD-Time give value as Current Date.</P><P></P><P>Chart how i want after new refresh:</P><P>Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Place&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ADD-Time&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TERM-TIME</P><P>Pranav&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; India&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Current Date</P><P>Peter&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; America</P><P>Saurabh&nbsp;&nbsp;&nbsp;&nbsp; India&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Current Date</P><P></P><P>Please help its Urgent.</P><P></P><P>Regards,</P><P>Pranav</P></BODY></HTML> Wed, 15 Jan 2014 08:28:10 GMT 2014-01-15T08:28:10Z Creating new columns with new reload https://community.qlik.com/t5/QlikView/Creating-new-columns-with-new-reload/m-p/513547#M685622 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a QVD which has two column as 'Name' and 'Place' with value as:</P><P>Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Place</P><P>Pranav&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; India</P><P>Peter&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; America</P><P></P><P>I want to give another column in this as ADD-Time means.</P><P>If tomorrow when my QV app refreshes and checks with old qvd that my Column value Pranav is not in new refresh then in new column as TERM-Time give value as Current date.</P><P>And if a new Name has came Which was not in previous load example as Danny then in new column as ADD-Time give value as Current Date.</P><P></P><P>Chart how i want after new refresh:</P><P>Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Place&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ADD-Time&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TERM-TIME</P><P>Pranav&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; India&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Current Date</P><P>Peter&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; America</P><P>Saurabh&nbsp;&nbsp;&nbsp;&nbsp; India&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Current Date</P><P></P><P>Please help its Urgent.</P><P></P><P>Regards,</P><P>Pranav</P></BODY></HTML> Wed, 15 Jan 2014 08:28:10 GMT https://community.qlik.com/t5/QlikView/Creating-new-columns-with-new-reload/m-p/513547#M685622 2014-01-15T08:28:10Z Re: Creating new columns with new reload https://community.qlik.com/t5/QlikView/Creating-new-columns-with-new-reload/m-p/513548#M685623 <HTML><HEAD></HEAD><BODY><P>Have a look at this:</P><P><A href="https://community.qlik.com/docs/DOC-4597">Incremental Load</A></P></BODY></HTML> Fri, 17 Jan 2014 11:52:17 GMT https://community.qlik.com/t5/QlikView/Creating-new-columns-with-new-reload/m-p/513548#M685623 Anonymous 2014-01-17T11:52:17Z