May 06 2021 08:42 PM
Hi Team,
Hope you are doing well!... I am trying to count the number of diagnosis codes by context ,Specialty and provider..Can you please help me here..Attached the Input and the output required sheets....
Appreciate your help!
Thanks,
Arun
May 07 2021 01:00 AM - edited May 07 2021 01:05 AM
Solution@Arun Chandramouli Please see the attached file containing a PQ solution in the Output sheet. I have also noticed some discrepancies, probably caused by the fact that you created the example output manually.
The query is fairly standard, except for one little trick that allows you to split the "Diagnosis code" column based on the maximum number of elements in any given field. I picked it up from a video by @Wyn Hopkins not too long ago.
May 07 2021 02:05 AM
May 07 2021 02:12 AM
Thanks for the reference @Riny_van_Eekelen
There's actually a simpler way using Split Text to Rows option under Advanced
May 07 2021 03:25 AM
May 07 2021 03:40 AM
@Arun Chandramouli Not sure I follow. You mean that if, for instance, E1 in the table has two entries for the same diagnose, you only want to count it once?
May 07 2021 03:52 AM
May 07 2021 03:57 AM
@Arun Chandramouli Okay. Then try the attached version. I just entered an extra code on the first row and it only counts once in the output. Have also simplified the query using Wyn's tip. Also added a Trim step, that will get rid for any trailing or leading spaces in the diagnose column.
May 09 2021 11:56 PM
May 07 2021 01:00 AM - edited May 07 2021 01:05 AM
Solution@Arun Chandramouli Please see the attached file containing a PQ solution in the Output sheet. I have also noticed some discrepancies, probably caused by the fact that you created the example output manually.
The query is fairly standard, except for one little trick that allows you to split the "Diagnosis code" column based on the maximum number of elements in any given field. I picked it up from a video by @Wyn Hopkins not too long ago.