Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All
I need to find out cases where in, I have same PASS_NO but different names in Name field.
I am attaching sample data where in I need to find out the Blue colored highlighted records.
The frequency is greater than 1 in most of the entries.
Kindly help. Let me know if more details are required.
Thanks & Regards
Chintan Gala
You can try this expression on the front end of the application:
If(Count(DISTINCT TOTAL <[PASS NO]> NAME) > 1, 1, 0)
You want this to happen in the script or front end of the application?
May be this in the script to flag those PASS NOs
Table:
LOAD [PASS NO],
NAME,
ADDRESS
FROM
PASS_repeat.xlsx
(ooxml, embedded labels, table is Sheet1);
Left Join (Table)
LOAD [PASS NO],
If(Count(DISTINCT NAME) > 1, 1, 0) as Flag
Resident Table
Group By [PASS NO];
Dear Sunny
Thanks for your help.
Data is huge so is there anyway to do in front end. I have used similar expression in front end, but it does not pick all the PASS_NO which are repeating for different names.
Thanks & regards
Chintan Gala
You can try this expression on the front end of the application:
If(Count(DISTINCT TOTAL <[PASS NO]> NAME) > 1, 1, 0)
Thanks a lot Sunny, it works perfectly as required!! If you can explain the expression a bit in brief.
In my application after applying your expression I get only repeated ones. however in your application u shared we can also see the 0 ones . Have u done any additional settings?
Thanks & regards
Chintan
Hello Sunny
I believe it is Supress zero value check box in Presentation..
This will work for both NAME and ADDRESS
If(Count(DISTINCT TOTAL <[PASS NO]> NAME) > 1, 1, If(Count(DISTINCT TOTAL <[PASS NO]> ADDRESS) > 1, 1))
Hope this will helps u..!!
Regards,
Mohammad
Thanks Mohammad , this can be used for other additional reports!
You are right, I unchecked 'Suppress Zero Values' on the presentation tab to show 0s