Want to Retrieve Imported data while importing in Excel?
Hi Experts, I have a customer and order entity with one to many associations so that one customer will have multiple order details. Here I am adding customer and their order details via Excel Import, and did successfully. REQUIREMENT: 1) Here I am importing customer and their order details in a single excel sheet, I want to check whether the imported customer data is existed already or not, if it is existed I want to map those new order details to the existed customer. 2) If the customer is not existed I want to create a new customer object and I need to map those order details for the new customer. Answers are really Appreciated!
The best control over processing the data would be to import the data in two import entities and then process this with the help of a microflow. In the microflow create the sub microlfows to find or create the customer and orders.