Linking two modules with two different dimension
I have an issue that I may need some help with. Below is the sample table:
Gencon Module (Source) - GenCon List
Inventory Module (Target) - Inventory List
Gencon Module is the transactional data of the client. In the Gencon Module it is normal to see multiple transaction code with different Start Date, End date and Status.
Inventory Module is the filtered version of the Gencon Module. Only the Transaction ID with Fully Paid status and those transaction ID without duplicates and End Date will be displayed as Unsold.
The Inventory Table above is the expected result. The Table below is the current result that we got:
we tried using If else condition but we have an error level dimension mismatch.
Appreciate the help.