Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
Please help me
i have 4 condition and i am not able to put my condition in If condition
could you please help me
please find the scaniario
CASE #1: If BA_TEST_CODE = 'SY', and Stamp code>=9000 and Stamp code<=9999
then 'LYMP else 'LYDP'.
CASE #2: If BA_TEST_CODE = 'IL' then set as 'ILA'
CASE #3: If BA_TEST_CODE = 'PS' then set as 'LRA'
CASE #4: BA_TEST_CODE IS NOT ('SY', 'IL', 'PS') then set as 'POOL'
IF(BA_TEST_CODE = 'IL', 'ILA',
IF(BA_TEST_CODE = 'PS', 'LRA',
IF(BA_TEST_CODE = 'SY' and Stamp_Code >= 9000 and Stamp_Code <= 9999, 'LYMP',
IF(BA_TEST_CODE = 'SY' and (Stamp_Code < 9000 or Stamp_Code > 9999), 'LYPD',
IF(Not Match(BA_TEST_CODE,'IL','PS','SY'),'POOL')))))