Forum Discussion

fab196's avatar
fab196
Helper II
5 years ago
Solved

comparing two columns


HI ,

CAN anyone help me with this problem

my data is listed below

what i want :

i want table chart result if the column are nt matching then and then the number of rows should be displayed.

for example in my data:

countrystateMg1mg2
inmhpd
in krpp
us mipp
us ca p

for example in my data ,coutry , mg1 and mg is there.if mg1 value <> mg2 then and then result should be shown otherwise not and if tone the mg1 and mg2 feild have null values then this row
should be ignore.

so the final result should be

countrystateMg1mg2
in krpp
us mipp

please help

parry2k 

amitchandak 

Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    5 years ago

    fab196 , The result is showing mg1 = mg2 in the output table you shared.

     

    Add this measure with other columns

    countrows(filter(Table, [Mg1] = [mg2] && not(isblank([Mg1])) && not(isblank([mg2]))))

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    fab196 , The result is showing mg1 = mg2 in the output table you shared.

     

    Add this measure with other columns

    countrows(filter(Table, [Mg1] = [mg2] && not(isblank([Mg1])) && not(isblank([mg2]))))