https://community.qlik.com/t5/Talend-Studio/import-master-detail-from-excel-into-sql-tables-with-GUID-id/m-p/2377033#M139010 Hello,<BR />I want to import from excel into an SQL table something like this:<BR />master table Student (IDStudent as GUID, Name) <BR />detail table Grade (IDGrade as GUID, IDStudent as GUID, Grade)<BR />How can I obtain the IDStudent from the master table for inserting into the detail table? I read about the same thing, but that example had the ids autoincrement and with the lastinsertid was not a problem for importing.<BR />Any suggestions would be very appreciated!<BR />Thanks! Wed, 08 Jul 2015 13:14:01 GMT Anonymous 2015-07-08T13:14:01Z https://community.qlik.com/t5/Talend-Studio/import-master-detail-from-excel-into-sql-tables-with-GUID-id/m-p/2377033#M139010 Hello,<BR />I want to import from excel into an SQL table something like this:<BR />master table Student (IDStudent as GUID, Name) <BR />detail table Grade (IDGrade as GUID, IDStudent as GUID, Grade)<BR />How can I obtain the IDStudent from the master table for inserting into the detail table? I read about the same thing, but that example had the ids autoincrement and with the lastinsertid was not a problem for importing.<BR />Any suggestions would be very appreciated!<BR />Thanks! Wed, 08 Jul 2015 13:14:01 GMT https://community.qlik.com/t5/Talend-Studio/import-master-detail-from-excel-into-sql-tables-with-GUID-id/m-p/2377033#M139010 Anonymous 2015-07-08T13:14:01Z https://community.qlik.com/t5/Talend-Studio/import-master-detail-from-excel-into-sql-tables-with-GUID-id/m-p/2377034#M139011 <A href="https://www.talendforge.org/forum/viewtopic.php?pid=165367#p165367" rel="nofollow noopener noreferrer">https://www.talendforge.org/forum/viewtopic.php?pid=165367#p165367</A> solved my problem&nbsp; <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MACn.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154443iC5B8CACEF3D12C6A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MACn.png" alt="0683p000009MACn.png" /></span> Fri, 10 Jul 2015 08:30:54 GMT https://community.qlik.com/t5/Talend-Studio/import-master-detail-from-excel-into-sql-tables-with-GUID-id/m-p/2377034#M139011 Anonymous 2015-07-10T08:30:54Z