topic Incremental loads with evolving status in QlikView https://community.qlik.com/t5/QlikView/Incremental-loads-with-evolving-status/m-p/581605#M216025 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I'm new to Qlikview and having difficulties with Incremental Load.</P><P>I try to update a QVD using 2 fields&nbsp; :</P><P></P><TABLE border="1" class="jiveBorder" style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; WIDTH: 100%; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Order n°</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Status</STRONG></TH></TR><TR><TD style="padding: 2px;">103450</TD><TD style="padding: 2px;">Delivered</TD></TR><TR><TD style="padding: 2px;">103451</TD><TD style="padding: 2px;">Delivered</TD></TR><TR><TD style="padding: 2px;">103452</TD><TD style="padding: 2px;">Loaded</TD></TR><TR><TD style="padding: 2px;">103453</TD><TD style="padding: 2px;">Not plannified</TD></TR></TBODY></TABLE><P></P><P>First, every line with a new Order n° must be added (that one's easy).</P><P>Then every line where the status has changed must be updated, final status being 'Delivered'.</P><P></P><P>Thanks in advance,</P><P></P><P>Regards,</P><P></P><P>Matthieu JUNIER</P></BODY></HTML> Mon, 17 Mar 2014 09:10:18 GMT 2014-03-17T09:10:18Z Incremental loads with evolving status https://community.qlik.com/t5/QlikView/Incremental-loads-with-evolving-status/m-p/581605#M216025 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I'm new to Qlikview and having difficulties with Incremental Load.</P><P>I try to update a QVD using 2 fields&nbsp; :</P><P></P><TABLE border="1" class="jiveBorder" style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; WIDTH: 100%; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Order n°</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Status</STRONG></TH></TR><TR><TD style="padding: 2px;">103450</TD><TD style="padding: 2px;">Delivered</TD></TR><TR><TD style="padding: 2px;">103451</TD><TD style="padding: 2px;">Delivered</TD></TR><TR><TD style="padding: 2px;">103452</TD><TD style="padding: 2px;">Loaded</TD></TR><TR><TD style="padding: 2px;">103453</TD><TD style="padding: 2px;">Not plannified</TD></TR></TBODY></TABLE><P></P><P>First, every line with a new Order n° must be added (that one's easy).</P><P>Then every line where the status has changed must be updated, final status being 'Delivered'.</P><P></P><P>Thanks in advance,</P><P></P><P>Regards,</P><P></P><P>Matthieu JUNIER</P></BODY></HTML> Mon, 17 Mar 2014 09:10:18 GMT https://community.qlik.com/t5/QlikView/Incremental-loads-with-evolving-status/m-p/581605#M216025 2014-03-17T09:10:18Z Re: Incremental loads with evolving status https://community.qlik.com/t5/QlikView/Incremental-loads-with-evolving-status/m-p/581606#M216026 <HTML><HEAD></HEAD><BODY><P>Don't you have any datetime column for updates ? How the status being updated ?</P></BODY></HTML> Mon, 17 Mar 2014 09:22:05 GMT https://community.qlik.com/t5/QlikView/Incremental-loads-with-evolving-status/m-p/581606#M216026 manojkulkarni 2014-03-17T09:22:05Z Re: Incremental loads with evolving status https://community.qlik.com/t5/QlikView/Incremental-loads-with-evolving-status/m-p/581607#M216027 <HTML><HEAD></HEAD><BODY><P>I don't have access to these columns if they exist ... I actually work with a flat extraction from a partner's DB</P></BODY></HTML> Mon, 17 Mar 2014 09:28:00 GMT https://community.qlik.com/t5/QlikView/Incremental-loads-with-evolving-status/m-p/581607#M216027 2014-03-17T09:28:00Z