I need to create a concatenated key based on a field I did a left join to.
In the EPIC_CHECKBOOK the field is %CHECKBOOK_MONTH_MODULE. In the other table, I left joined to add the field WORK_NAME to the APP_QV_RCM.QVD. I need to get something like date(TRX_DATE,'MM/DD/YYYY')&'-'&WORK_NAME as %CHECKBOOK_MONTH_MODULE. Is it even possible?
LOAD *,date(TRX_DATE,'MM/DD/YYYY')&'-'&WORK_NAME as %CHECKBOOK_MONTH_MODULE RESIDENT APP_QV_RCM;
EPIC_CHECKBOOK: LOAD Division, Module, date(Month,'MM/DD/YYYY') as CHECKBOOK_MONTH, date(Month,'MM/DD/YYYY')&'-'&Module as %CHECKBOOK_MONTH_MODULE, Division&'-'&Module&'-'&date(Month,'YYYY/MM') as %DIV_MODULE_MONTH_KEY, [Hours Type] as TASK_TYPE_OPT, Division&' '&if (left([Hours Type], 😎 = 'National','',[Hours Type]) as %DIVISION_TASK_TYPE_KEY, [Available Hrs.] as AVAIL_HOURS FROM [..\External_Data\Epic Checkbook Capacity 12.1.20.xlsx] (ooxml, embedded labels, table is Checkbook);