https://community.qlik.com/t5/Connectivity-Data-Prep/Create-a-row-based-on-two-rows/m-p/2003954#M11610 <P>So i have a table&nbsp;</P> <P>id&nbsp; message</P> <P>01 started</P> <P>01 finished&nbsp;</P> <P>i want to created a row&nbsp;</P> <P>01 finished&nbsp;</P> <P>but the difference is that some rows with "started" do not have a corresponding "finished".</P> <P>So based on this condition the message should be filled with "finished" or "failed"</P> <P>How do i do this?&nbsp;</P> <P>&nbsp;</P> <P>Regards&nbsp;</P> Mon, 14 Nov 2022 08:25:09 GMT qliker3 2022-11-14T08:25:09Z https://community.qlik.com/t5/Connectivity-Data-Prep/Create-a-row-based-on-two-rows/m-p/2003954#M11610 <P>So i have a table&nbsp;</P> <P>id&nbsp; message</P> <P>01 started</P> <P>01 finished&nbsp;</P> <P>i want to created a row&nbsp;</P> <P>01 finished&nbsp;</P> <P>but the difference is that some rows with "started" do not have a corresponding "finished".</P> <P>So based on this condition the message should be filled with "finished" or "failed"</P> <P>How do i do this?&nbsp;</P> <P>&nbsp;</P> <P>Regards&nbsp;</P> Mon, 14 Nov 2022 08:25:09 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Create-a-row-based-on-two-rows/m-p/2003954#M11610 qliker3 2022-11-14T08:25:09Z