topic How to find a single record in a data source in QlikView

How to find a single record in a data source

upaliwije — Fri, 12 Jul 2019 08:01:36 GMT

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 .

Re: How to find a single record in a data source

lockematthewp — Thu, 18 Jul 2019 17:43:51 GMT

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 ….