John Mulhall
- Total activity 14
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 3
- Subscriptions 0
Comments
Recent activity by John Mulhall-
Thanks Jason, that makes perfect sense...
-
Thanks Gido & Joel... the Booleans work for me and have added value to the analysis... onwards we go bro's!
-
Hey Joel.. any other cool commands that are not immediately obvious like GT that a relative newbie like me would like. I presume LT is a command also?
-
Joel, thank you for this. It was a silly mistake! I have corrected my error and it works just fine. Will be back with more questions.. I am generating them as a I work an analysis..
-
Hi, thanks for the formula dude.. it crashed the sheet with on both occassions with Sheet contains errors. Sheet 'CrashData2010' referenced in 'ProcDataSheet' does not exist in: [NYC_NYPD_CrashData...
-
Thanks Joel, so it basically works like a manual version of the DISTINCT command in SQL, right?
-
Thanks Joel for your continuing engagement on this. So, if I GROUPBY (#Column A) and row 1 and 3 (col A) have identical identifiers, will the dulicate cell in Col A be removed or will be row/record...
-
Joel, thanks for this. Much appreciated! It seems like a cumbersome way to deduplicate records in a process. Is there any specific function to do de-deduplicate records like the "UNIQUE" function f...
-
So to clarify, if you use GROUPBY(#FirstColumn), Datameer will match rows by first column, and then check every column on the sheet to make sure the role is truly duplicated? e.g. abc, xyz, 123,...