Qlik beginner

[Sureshbabukapu]

Hai all, 

My self suresh iam a student and qlik beginner, 

My task:

Please create new logic based field in the VDRITM_SUST Table.

New Field: SUSTAINABLE

Logic: If any of the following attributes = “Y”, then SUSTAINABLE = “Y”

AASHE_STARS
AGA_GRASS_FED
AMR_HUMANE_CERT
AMR_HUMMANE_CER_CAGE_FREE
AQUA_CULTURE_STWD_COUNCIL
B_CORP_CERT
BAP
CAGE_FREE
CERT_HUMANE_RAISE_HANDLE
CERT_RESP_ANTIBITOIC_USE
COMPOST_PKG
CONVSERV_ALLI_SEAFOOD_SOLUTIONS
FAIR_FOR_LIFE
FAIR_TRADE
GLOBAL_ANIMAL_PRTNRSHP
GROUP_HOUSED
HEALTHCARE_WOUT_HARM
MARINE_STWD_CNCL_BLUE_LABEL
MARINE_STWD_COUNCIL
MBE_MANUFAC_CERT
MEETS_ARAMARK_COMMITMENT
MONTEREY_BAY_SEAFOOD_WATCH
NAE
NON_GMO_VERIFY
PLANT_BASED
RAINFOREST_ALLIANCE_CERT
SALMON_SAFE_CERT
SB_COFFEE_FARMER_EQUITY
SCS
SUSTAIN_INST_AFFIRMED
USDA_CERT_ORGNAIC
WBE_MANUFAC_CERT

MEETS_ARAMARK_COMMITMENT

HOW CAN I IMPLEMENT THIS PLEASE HELP ME

Thanks, 

Suresh

[vikasmahajan]

Retirement is not clear what exactly you need to achieve ?  elaborate more in detail.

Vikas

[mikaelsc · Accepted solution]

if(substringcount(AASHE_STARS&AGA_GRASS_FED&AMR_HUMANE_CERT&AMR_HUMMANE_CER_CAGE_FREE&...,'Y'),'Y','N') as Sustainable