AnsweredAssumed Answered

Use Cross Reference Table like database table to perform column update

Question asked by tatneng.see231778 on Jun 21, 2017
Latest reply on Jun 21, 2017 by Sjaak Overgaauw

Is this possible to make use of cross reference table like database table not only to perform query but also column value update? We have a use case to store a static set of data row in either Boomi or DB, but there is one column is required to be updated. As shown in the table below, both task code and task parameter are static data column but Response ID column need to be updated for one time if it is initially null. I was just try to explore is it possible to do so or i need to make use of process property and tick the persisted?


Task Code      Task Parameter      Response ID


Task A            USD                     123456-1

Task B            EUR                     <null>