Hi Andreas_Ids or anyone else, can you show me how to use the Resolve function. I tried following the example in one of the links provided, however that example is resolving mathematical expression, different from what I am trying to achieve. I also tried other examples on this board and could not get the results.. As you mentioned I did merge the dataset with by the key values so now I have a dataset that looks like this: Main dataset (snippet) RefCheck StatCheck Stat ACCOMMFLAG Stat is missing ADMINISTRATION Stat ="&Admin." 11111111A DATERUN Stat ="&today." 10/22/2018 DELMODE Stat ="MST" MST EXCLUDE Stat is missing FLDSCRFLAG Stat is missing GENAUTO Stat ="Yes" Yes GENSKM Stat ="PROD" PROD MSTTOT input(Stat,8.) >0 29144 lookup dataset: RefCheck StatCheck TOTAL input(Stat,8.) >0 MSTTOT input(Stat,8.) >0 MSTVAL input(Stat,8.) >0 QVDOM input(Stat,8.) >0 QVINT input(Stat,8.) >0 WDOM input(Stat,8.) >0 WINT input(Stat,8.) >0 ACCOMMFLAG Stat is missing ADMINISTRATION Stat ="&Admin." DATERUN Stat ="&today." DELMODE Stat ="MST" EXCLUDE Stat is missing FLDSCRFLAG Stat is missing GENAUTO Stat ="Yes" GENSKM Stat ="PROD" OPTIONLIB Stat ="G:\\fortnt" PROGRAM Stat ="GRE" Q1SECTTERM Stat in ("0", "3", "4", "5") Q2SECTTERM Stat in ("0", "3", "4", "5") RECTYPE Stat ="DTL" REGID Stat ="ERS" SIRB Stat ="Populated" SIRM Stat ="Populated" SCRIND Stat not in("C") SCRPHASE Stat in("RPTBL" "SCRD" "READYTOARC SESRSTRT Stat in("0", "3", "4", "5") SESTERM Stat in("0", "3", "4", "5") SKMQNT01ANS input(Stat,8.) >=0 SKMQNT02ANS input(Stat,8.) >=0 SKMVBL01ANS input(Stat,8.) >=0 SKMVBL02ANS input(Stat,8.) >=0 SKMWRT00ARG input(Stat,8.) >=0 SKMWRT00ISS input(Stat,8.) >=0 SPARSEMATRIX input(Stat,8.) >=0 TEST Stat ="GEN" V1SECTTERM Stat in("0", "3", "4", "5") V2SECTTERM Stat in("0", "3", "4", "5")
... View more