Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I create the following table in the script:
Hired_Application:
Load ID AS APP_ID
WHERE PRE_STATUS='HIRED'.
In the expression I want to add a condition (in red below) that the expression will calculated only the id's that exists
in table Hired_Application..
Avg(aggr(
IF(UPPER(STATUS)='HIRED' and ID EXISTS IN APP_ID from table Hired_Application ,DAYS)
,JOB_REQ_ID,FROM_STATUS,TO_STATUS))
Could you please advise?
Thank's!!
try loading the field again by different name in data model
Load ID AS APP_ID,
ID AS APP_ID1
WHERE PRE_STATUS='HIRED'.
and use
Avg(aggr(
IF(UPPER(STATUS)='HIRED' and ID=APP_ID1 ,DAYS)
,JOB_REQ_ID,FROM_STATUS,TO_STATUS))
It would be great if you provide sample data
try loading the field again by different name in data model
Load ID AS APP_ID,
ID AS APP_ID1
WHERE PRE_STATUS='HIRED'.
and use
Avg(aggr(
IF(UPPER(STATUS)='HIRED' and ID=APP_ID1 ,DAYS)
,JOB_REQ_ID,FROM_STATUS,TO_STATUS))
It would be great if you provide sample data