Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
I have following data table in my QV doc.
From the data table I want to mark record highlighted in yellow as Y in a separate field namely 'FLAG' In other words all single record (RISK) with TRN_TYPE= 'R' should be marked as 'Y' in the FLAG field in Data load script. Kindly help me with syntax for it .
When loading your data in the script, just create another field called FLAG. Like:
LOAD [POLICY_NO],
[R_SEQ],
[RISK],
[TRN_TYPE],
[FROM_DATE],
if (count([RISK]) = 1 and [TRN_TYPE] = 'R', 'Y', 'N') as [FLAG]
FROM ….