Salesforce Flow and Data Taxonomy
Budget: £20 – £250 GBP
I require a Salesforce flow expert to solve the following use case:
Millions of property records are imported into a custom object using Data Loader. The same property can have many records, each relating to the last transaction. (e.g. House name, Location, County, Post code, Price paid etc.) -This raw data is uploaded monthly.
I then need to process this raw data before deleting it.
Processes to undertake:
1) Create unique Property records in a custom object
2) Create unique Transaction records in a custom object and link to the Property record
3) Create unique Post code records in a custom object and link to the Property record
4) Create unique Location records in a custom object and link to the Property record.
A postcode can have many properties.
A location can have many properties.
A Property can have many Transactions
The objects, relationships and fields have been created but I am unable to create a flow for my use case. Each attempt results in multiple records being created.
Millions of property records are imported into a custom object using Data Loader. The same property can have many records, each relating to the last transaction. (e.g. House name, Location, County, Post code, Price paid etc.) -This raw data is uploaded monthly.
I then need to process this raw data before deleting it.
Processes to undertake:
1) Create unique Property records in a custom object
2) Create unique Transaction records in a custom object and link to the Property record
3) Create unique Post code records in a custom object and link to the Property record
4) Create unique Location records in a custom object and link to the Property record.
A postcode can have many properties.
A location can have many properties.
A Property can have many Transactions
The objects, relationships and fields have been created but I am unable to create a flow for my use case. Each attempt results in multiple records being created.