https://community.qlik.com/t5/Data-Quality/How-to-implement-in-Talend/m-p/2204413#M743 <P>Hi,</P><P>I have a requirement in talend. I have identified parent and child records using tMatchmodel component. Now i need to build the logic for assigning the relation in between record to record. </P><P>I am adding 3 additional columns as part of my development to create the hierarchy.</P><OL><LI>Family ID</LI><LI>Parent ID</LI><LI>Child ID</LI></OL><P>Attached the sample data how it looks like. Highlighted are the ones, I need to generate based on the status. Blue are the ones coming from source. </P><P>Please let me know how to implement this and assign the values for familyid, parentid, child id, insert time stamp, </P><P>insert time stamp, insert by &amp; update by based on the sample data that I have provided.</P><P>&nbsp;</P><P>Note: I have oracle database for staging tables</P> Sat, 16 Nov 2024 00:45:51 GMT PChereddy 2024-11-16T00:45:51Z https://community.qlik.com/t5/Data-Quality/How-to-implement-in-Talend/m-p/2204413#M743 <P>Hi,</P><P>I have a requirement in talend. I have identified parent and child records using tMatchmodel component. Now i need to build the logic for assigning the relation in between record to record. </P><P>I am adding 3 additional columns as part of my development to create the hierarchy.</P><OL><LI>Family ID</LI><LI>Parent ID</LI><LI>Child ID</LI></OL><P>Attached the sample data how it looks like. Highlighted are the ones, I need to generate based on the status. Blue are the ones coming from source. </P><P>Please let me know how to implement this and assign the values for familyid, parentid, child id, insert time stamp, </P><P>insert time stamp, insert by &amp; update by based on the sample data that I have provided.</P><P>&nbsp;</P><P>Note: I have oracle database for staging tables</P> Sat, 16 Nov 2024 00:45:51 GMT https://community.qlik.com/t5/Data-Quality/How-to-implement-in-Talend/m-p/2204413#M743 PChereddy 2024-11-16T00:45:51Z