Skip to Content
0
Former Member
Nov 04, 2015 at 04:58 PM

Comparison algorithm

19 Views

Hello experts,

I have a question a bit (or a lot...) tricky. I would use an comparison algorith between 2 datastores (or 2 crosstab)

I have 2 crosstab which have the same dimension name and the same keyfigure. (for exemple : Country and quantity for both crosstab).

I want to compare for each country the quantity i have in order to verify if i have the same value in each crosstab. Comparison will be done according to the internal key, not the position in the crosstab.

DS_1 : FRANCE 10 , ITALY 15, RUSSIA 10, SPAIN 20

DS_2 : FRANCE 10, RUSSIA 15, SPAIN 20

Problem : In this exemple, if i'm able to compare value for France, how i have to manage my method if one of a country is missing in one of the crosstab, and continue the algorithm with the next country ?

I hope you will understand my issue, it was hard to explain the concept, so tell me if i need to complete my explication.

Regards,

Jonas.