Hi experts,
I am in need of your expert opinion in regards to the below matter:
I have two columns coming from two different data input files. They both include the same information but in different order and format.
I have attached a screenshot of from the output result.
As noted that all variables in col Business rules per AXIOM are included in the col Business rules per Regulator but in different format
e.g. row 1 col Business rules per AXIOM BAS+CPS+LQA+MCY+x27+x10+x196+x25 are also included in the business rules per regulator but BAS=eba_BA:x27,CPS=eba_CT:x10,LQA=eba_LQ:x196,MCY=eba_MC:x25 as underlined.
Is there a way to compare and validate that the information in both columns is same?
Kind regards,
Raffay
