This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
IF Contains([Taxonomy used],'E') AND [Matching Status]='MATCHED' THEN 'RECONCILED' ELSEIF Contains([Taxonomy used],'E') AND [Matching Status]='UNMATCHED1' THEN 'UNMATCHED' ELSEIF Contains([Taxonomy used],'E') AND [Matching Status]='UNMATCHED2' THEN 'MATCHED' ELSE Null() ENDIF
I need some more help please it has come a bit more complicated unfortunately. The above formula worked however I have missed something. There are 2 sides to my trades ( Ours/Trade vs Clients/Allege) and the client side does not have the Taxonomy populated but I need the Taxonomy and match status on both the Trade/Allege sides. So now I need to create 2 new columns "New Unmatched status" & "Taxonomy updated".
New column: Taxonomy Updated - Where Trade ID is the same for both Trade and Allege (column A) if Taxonomy Used is E on the Trade side Taxonomy updated needs to have E for both sides. If Taxonomy used is blank on Trade side then remain blank for both sides so that I can use the formula above as currently only getting one side of the trade with the correct new matched status. I have added a table below.
Sorry for the example table format, I cannot paste a table or picture as it is blocked internally. Any help would be appreciated 🙂
Trade/Allege Trade ID Matching Status Taxonomy Used Current formula only updates one side Taxonomy Updated New Unmatched status