https://community.qlik.com/t5/Talend-Studio/UPSERT-with-dynamic-schema/m-p/2289605#M62977 <P>Hi, we are using a framework to load about 60 tables from salesforce to snowflake. I want to update the existing record if there is an update in the source. But as we are using dynamic schema I am clueless how to implement this. Please provide your suggestions. If we have the solution we will implement the same for other sources as well(SQLserver)</P> Fri, 15 Nov 2024 23:09:08 GMT RFAM1 2024-11-15T23:09:08Z https://community.qlik.com/t5/Talend-Studio/UPSERT-with-dynamic-schema/m-p/2289605#M62977 <P>Hi, we are using a framework to load about 60 tables from salesforce to snowflake. I want to update the existing record if there is an update in the source. But as we are using dynamic schema I am clueless how to implement this. Please provide your suggestions. If we have the solution we will implement the same for other sources as well(SQLserver)</P> Fri, 15 Nov 2024 23:09:08 GMT https://community.qlik.com/t5/Talend-Studio/UPSERT-with-dynamic-schema/m-p/2289605#M62977 RFAM1 2024-11-15T23:09:08Z https://community.qlik.com/t5/Talend-Studio/UPSERT-with-dynamic-schema/m-p/2289606#M62978 <P>Hi, you could have issue with dynamicShema to set a primary key , you could force it in the Dynamic metadata with the setKey() function but you have to know the name of the primary key column or it position.</P> Tue, 08 Mar 2022 08:26:32 GMT https://community.qlik.com/t5/Talend-Studio/UPSERT-with-dynamic-schema/m-p/2289606#M62978 gjeremy1617088143 2022-03-08T08:26:32Z