I have almost 100 columns. For each column I need to validate certain rules and mark it as Y or N in the report. Please suggest on the best way.
Rule1Rule2Rule3Rule4Rule5Rule6Rule7Rule8Field 1 Field 2 NNNNNN Field 3 Field 4 Field 5 Field 6 Field 7 Field 8 Field 9 Field 10 Y Field 11 Y Field 12 Y Y
Variable NameData TypeRule1Rule2Rule3Rule4Rule5Rule6Rule7Rule8A_CD NNull 0Negative Values B_LOCATION CBlankwith N/A IN('U','UA','A') P_CODE CBlankwith N/A > ' ' AND LENGTH(TRIM(LEFT(P_CODE))) IN(5,9))
1 answer
Hi, Archana
Can you provide a sample workbook?
ZZ
