Populating mandatory fields in Data entity staging table

(0) Share

Report

Posted on by BrandonSA

1,673

Hi everyone

I have a table called MyTable with mandatory/key fields on it called FieldA and FieldB. It also has a non-mandatory field called FieldC.

I want to import data into MyTable using Data management using Excel or Dual-write. In the source, I have data for FieldB and FieldC. I want to use the data in FieldC to populate FieldA.

How do I do this?

- The only staging table methods I have access to is postLoad at which time FieldC isn't populated yet

- there is a postGetStagingData method but it doesn't work with odata

- if I populate FieldA using FieldC in an entity method like mapDataSourceToEntity, then the target field gets populated successfully, but since FieldA isn't populated in the staging table, FSC creates records instead of updating them

I've heard of importing data into a temp table, and then processing the data from there. Are there any other 'proper' solutions?

Thanks

I have the same question (0)