Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
How do i create a dimension or expression the check another column for matching fields?
As per attachment: Create a Dimension called Unique Doc No Count that will check the 'Doc no' column. If the below field does not match the above field then mark as 1. It it matches, mark the top one a 1 and the duplicates as 0.
This is to enable to to filter for Unique Doc No.
please below attachment for further undertanding.
On Excel i would've used =IF(A2<>A1,1,0)
Regards
Charles
This could be done with Peek() or Previous() ? for example:
Load [Doc no], if([Doc no] <> previous([Doc no]), 1, 0) as Check Resident xyz order by [Doc no];
- Marcus