I have to Import "product in order" data from excel file but it cannot match 2 field in table name: order with order no and order date

In database I have Order table and Product in Order Table. The Order table i have the same Order no but it not a same record because it order created a different day

Ex.

OrderNo : 0001 Created : 2022-01-21

OrderNo : 0001 Created : 2022-02-21

 

The problem is I cannot import Product in Order table data by match order no and date in Order table

 

 

How import data by excel file with same order no but different date and different record

Like 0

Like

1 comments

Maybe you could create a single column in Creatio to store order number + date, then in the Excel file use a formula to append the values together and map that value to link to the order? 

Ryan

Show all comments