Data Studio
4K members online now
4K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

File Upload CSV File - Silent Error Parsing Integer With Quotes At End Of Line Only

Follower ✭ ☆ ☆
# 1
Follower ✭ ☆ ☆

The following uploads and verifies as correct even though ROW 2 is imported with the last column set to zero....

 

Date,Advertiser,Advertiser_ID,Insertion_Order,Insertion_Order_ID,Creative,Creative_ID,Sizmek_ID,Revenue,Viewable_Impressions,Total_Net_Measured_Impressions

3/8/2017,A,966539,B,2901128,C,36453676,19966088,383,"589,534",1001

3/8/2017,A,966539,B,2901128,C,36453676,19966088,365,"589,534","1,010"

3/8/2017,A,966539,B,2901128,C,36453676,19966088,383,"589,534",1100

 

Row #2 will import but the last column is set to 0 instead of "1,010".  No errors no flags.  This only happens to quoted numbers at the end of a row. In the image below the last column should be 3,111 but its 2,102.

 

Screen Shot 2017-03-08 at 8.00.03 AM.png