5_1. COVID-19 Patient Automated Message Generator by Doctor_Standard Version
Notice Regarding Date of Birth Serial Number Output
The date appears as a serial number, but you can convert it to a 6-digit date of birth using a text function.
Since the core of this module is conditional column consolidation, we have omitted the date of birth conversion process.
This is because including this part would make the video too long and could cause us to stray from the main topic.
If you have any questions, please contact us separately, and we will provide you with detailed information.
Reference Videos
[Functions] 21. COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS : • [함수] 21.COUNT,COUNTA,COUNTBLANK,COUNTIF,CO...
[Functions] 50. CONCATENATE Function : • [함수] 50.CONCATENATE 함수
Example File : https://blog.naver.com/pig075/2212341...
Mania Official Open KakaoTalk Room : https://open.kakao.com/o/gLti8djb
1:1 KakaoTalk Inquiry : https://open.kakao.com/o/sr9OUfG
Email : [email protected]
Timestamps
00:00 Problem and Video Explanation
01:50 Start of Standard Version
02:55 Concept Explanation_Index by Group
05:12 Concept Explanation_CHAR Function
08:34 Concept Explanation_Accumulated Text for Entire Column
10:01 Confirmed Case Information
10:50 Number of Confirmed Cases by Doctor
11:34 Confirmed Case Number by Doctor
2:44 Generating Notification Messages
16:05 Filtering Generated Notification Messages