Hi Kurt,
Thank you for the advise. Noted and Thank you!
Have data :
ID
Status
Code
System
Name
Value
Rule_Label
123XXX
Active
BDD
EXX
City
C07
City: Numeric,City: Special Characters
123XXX
Active
CDD
ABB
City
C07
City: Numeric,City: Special Characters
123XXX
Active
ADD
CAA
City
-
City: Special Characters
123XXX
Active
ADD
CAA
City
Occupation: Blank
456XXX
Inactive
ADD
CAA
State
State: Blank
456XXX
Inactive
ADD
CAA
Code
111
mismatch
456XXX
Active
CDD
CAA
Code
\M
blank
456XXX
Active
CDD
CAA
City
c13
City: Numeric,City: Special Characters
789XXX
Inactive
CDD
ABB
Code
N41
City: Numeric,City: Special Characters
910XXX
Active
MMM
ABB
City
8
City: Numeric,City: Special Characters
Needed data set:
ID
Status
Code
EXX
ABB
CAA
EXX
ABB
CAA
EXX
CAA
ABB
Code
Rule Label
Code
Rule Label
Code
Rule Label
City
Rule Label
City
Rule Label
City
Rule Label
State
Rule Label
State
Rule Label
State
123XXX
456XXX
456XXX
456XXX
456XXX
789XXX
910XXX
910XXX
Please help..
... View more