Forum Discussion

Quiny_Harl's avatar
Quiny_Harl
Icon for Advocate III rankAdvocate III
5 years ago

SUMMARIZE table without blanks

I would like to have all unique values from a column in order to use it as a dimension table. Here is how I do that: Yet, even though I'm excluding the blank ones I still have one blank. On to...
Need Help
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Are you sure it is blank and not a space or other character?  If so, please try DISTINCT(campaign_id[objective]) instead.  It will exclude the blank row.

Regards,

Pat