I think I confused everyone with my post. I apologize for that. So, I am posting here with a sample

My source file has data like below

PA,East,USA

CA,West,USA

FL,South,USA

WA,North,USA

and my lookup table in SQL database has the below information

Short_Name Long_Name

PA Pennsylvania

CA California

FL Florida

And I am using a lookup task to convert my column1 in the source file to Long_Name. When I execute my package my match output is like below (As expected)

Match Output from lookup

------- ------- ----- --------

Pennsylvania,East,USA

California,West,USA

Florida,South,USA

and my NoMatch output looks like below

,North,USA

What I am saying is if it wont find a match (in case of WA from sample data) I want to see my nomatch output as below

WA,North,USA

Appreciate your help. Tnx