Question
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
06:59 Aug 02, 2022
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
1 comments
18:43 Aug 02, 2022
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