Hi , I need to put  a condition in my sql code for not fetching the vlaue 'P' for a column clm_ind, tried<> and also not in in the where conditions but its not working. The column in charector with a length of 1. Tried with strip(clm_ind) not in 'P' but not working . Please advice me what would be the problem Thanks. ... View more

Hi Experts , I havea a data set that the values are showed like different raws and I want to make that raws in a single column .No problem if the claim and suffixs shows multiple times  the data Have  Claim Suffix  ICD10A  ICD10B  ICD10C ICD10D  ICD10E 12589 1         vvg         ijk           ghy        ilk            opl 12589 2          rty         ilk            rtr         erd           owe data want  Claim Suffix   ICD10 12589   1           vvg 12589   1           ijk 12589   1          ghy 12589   1         ilk 12589   1         opl 12589   2        rty 12589   2        ilk 12589  2        rtr 12589  2         erd 12589  2      owe How to proceed with this scenario Please advice ... View more

I have a data set and it contains Claim sfx and amount , I need to remove the duplicates claim , but the problem here is there could be different sfx in the same claim , if its different for the same claim then I need to keep that claim   Claim     sfx          amount                100         23           897         100         23           897         101         25           789         101         89           463         Need to keep this Claim because of different sfx 102         56           789         102         56           789         Need to delete this becase of same sfx ... View more