This content has been marked as final.
Show 5 replies
-
1. Re: Convert Null/Blank values to 0s
Alex Kerin Dec 5, 2012 3:02 PM (in response to yingyingchen0)What is your desired output from the data you provided?
-
2. Re: Convert Null/Blank values to 0s
yingyingchen0 Dec 5, 2012 3:14 PM (in response to Alex Kerin)i want to show something like below, so i can easily tell which web_id is missing what service of impressions.
i also attached the data feed below, i pulled the data from SQL, or there is a better way i should pull the data?
SERVICE
WEB_ID
maxpoint interactive video
Specific Media
gmps-abel
NA
12
gmps-advantage-il
NA
32,608
gmps-advantagechevy
NA
4,136
gmps-babe
NA
4,798
gmps-baird
NA
19
gmps-bale
NA
1
gmps-bankston
NA
1
gmps-beardmore
NA
1
…
gmps-young
NA
51
gmps-zanesville
NA
162
gmps-vandevere-chev
25,627
NA
BTW, the data feed looks like:
WEB_ID service impressions gmps-state maxpoint interactive video 410 gmps-country-il maxpoint interactive video 528 gmps-homan maxpoint interactive video 542 gmps-emerson-in maxpoint interactive video 646 gmps-midway-pontiac maxpoint interactive video 787 gmps-schimmer maxpoint interactive video 999 ......
gmps-state Specific Media 1 gmps-country-il Specific Media 3,155 gmps-homan Specific Media 6 gmps-emerson-in Specific Media 799 gmps-midway-pontiac Specific Media 33 gmps-schimmer Specific Media 9,677 gmps-harvard Specific Media 242 gmps-riverside-il Specific Media 2,435 gmps-billwalsh Specific Media 203 gmps-roger Specific Media 3,742 -
3. Re: Convert Null/Blank values to 0s
yingyingchen0 Dec 6, 2012 10:33 AM (in response to yingyingchen0)I have found a way to do this myself. Thanks everyone for help. Not sure if I should close this question and don't know how.
-
4. Re: Convert Null/Blank values to 0s
Diego Ibarra May 16, 2013 1:23 PM (in response to yingyingchen0)Tell us about the answer.
-
5. Re: Convert Null/Blank values to 0s
bart.groots Jun 27, 2014 8:17 AM (in response to yingyingchen0)thanks for sharing