In a Flat File source there r Null as well as Blank values .If u r doing the profiling for that source ,how do u gete counts for the Null and Blank separately instead of getting them as one countThanksManish

Jaspreet_banga

 Profile Answers by Jaspreet_banga Questions by Jaspreet_banga

• Jun 8th, 2011

For This first of all replace the null values by some default values and blank values by other default values then use Count(*) operator in select clause along with IN statement EG:-SELECT COUNT(*) FROM table_name WHERE coulmn_name IN('default_1','default_2');

S.Velava

 Profile Answers by S.Velava Questions by S.Velava

• Apr 13th, 2010

Use aggregate transformation with count to specify the null and blank.Count with the condition of not equal to null to get the count of blank values and as well to get the count of null values chk with the Null.

Answer Question  Select Best Answer