https://community.qlik.com/t5/Installing-and-Upgrading/If-update-if-insert/m-p/2398267#M8893 The way I use : <BR />I load the table I want to update and I make an inner join between this table and the source table. If it matches it's an update else it's an insert. Mon, 23 Jul 2007 14:54:38 GMT bdurand 2007-07-23T14:54:38Z https://community.qlik.com/t5/Installing-and-Upgrading/If-update-if-insert/m-p/2398266#M8892 Hi all, <BR />I have a table with columns "INS" and "UP". In action on data in TDBOuput, I choose "Update or insert". But when I insert I don't want to fill UP, and on update I mustn't update INS but fill UP. Is there an easy way to do that (without triggers)? <BR />I'm using TOS V2.1.0 with java. <BR />Kind regards <BR />Ben Sat, 16 Nov 2024 14:34:49 GMT https://community.qlik.com/t5/Installing-and-Upgrading/If-update-if-insert/m-p/2398266#M8892 bdurand 2024-11-16T14:34:49Z https://community.qlik.com/t5/Installing-and-Upgrading/If-update-if-insert/m-p/2398267#M8893 The way I use : <BR />I load the table I want to update and I make an inner join between this table and the source table. If it matches it's an update else it's an insert. Mon, 23 Jul 2007 14:54:38 GMT https://community.qlik.com/t5/Installing-and-Upgrading/If-update-if-insert/m-p/2398267#M8893 bdurand 2007-07-23T14:54:38Z https://community.qlik.com/t5/Installing-and-Upgrading/If-update-if-insert/m-p/2398268#M8894 i have found the solution, i have one job for the insert and an other for the update. <BR />inj the end of the insert, the update run automatically <BR />i have deleted the pb of same name of colonnes Tue, 19 Feb 2008 16:43:48 GMT https://community.qlik.com/t5/Installing-and-Upgrading/If-update-if-insert/m-p/2398268#M8894 Anonymous 2008-02-19T16:43:48Z https://community.qlik.com/t5/Installing-and-Upgrading/If-update-if-insert/m-p/2398269#M8895 Ok, this solutions are not answers to the problem, they are other ways to do what talend must do with "Action On Data" feature<BR />why it does not work?<BR />Are Talend Offering something that doesn't work? Thu, 21 Feb 2008 23:10:53 GMT https://community.qlik.com/t5/Installing-and-Upgrading/If-update-if-insert/m-p/2398269#M8895 _AnonymousUser 2008-02-21T23:10:53Z https://community.qlik.com/t5/Installing-and-Upgrading/If-update-if-insert/m-p/2398270#M8896 These feature has been add since 2.3. <BR />Go to your db output component preoperties / advanced settings / Advanced fields option : The Updatable and Insertable columns allows you to choose which fields needs to be inserted and which fields have to be updated <BR />Regards, Thu, 21 Feb 2008 23:29:20 GMT https://community.qlik.com/t5/Installing-and-Upgrading/If-update-if-insert/m-p/2398270#M8896 Anonymous 2008-02-21T23:29:20Z https://community.qlik.com/t5/Installing-and-Upgrading/If-update-if-insert/m-p/2398271#M8897 Hi all, <BR /> <BR /> Can anyone explain the same thing at data model level in MDM. <BR /> In the data model I have create date and update date. For both I gave current date as default value. But when I updating the record, create date is also changing to update date. Even I updated the record, the create date rule is also working. How can I get proper dates? <BR />Please help me out in this issue. <BR />Thanks in advance. <BR />Regards, <BR />Lalitha. Wed, 13 Jun 2012 10:10:39 GMT https://community.qlik.com/t5/Installing-and-Upgrading/If-update-if-insert/m-p/2398271#M8897 Anonymous 2012-06-13T10:10:39Z