Import result shows values are adding up from multiple codes
This issue is related from yesterday but with a different approach. We created a Gencon Module (transaction Data of client) and the Inventory Module (data from Gencon without the duplicates).
Gencon List has duplicate RU text (Transaction Code) which will be imported to Inventory List eliminating the duplicates and only capturing the RU text with Fully Paid status. Codes with no duplicate and Cancelled status in Gencon will be tagged as Unsold.
Below is the sample of the Gencon module. To forward this GenCon List and create an Inventory List the process we use is import action to eliminate the duplicates.
Below is the expected result after the import process.
Currently below is my result. As you can see the Status column got the wrong result on Transaction ID 422 and also the value for floor area duplicated.
Is there a way for me to capture the Status column for Fully Paid only and also to get the floor area without adding the other items on the GenCon List.
Appreciate the help in advance.