search

mediahackza / datadesk

0 stars 0 forks source link

Problem with format in Datadesk #34

Closed Fishbone17 closed 1 year ago

Fishbone17 commented 1 year ago

Hi Ciaran!

I uploaded a .csv of the following Google Sheet and when I looked at it in DataDesk, it threw out some of the columns. I have attached a screenshot.

Screenshot 2023-08-15 at 09 22 18

And the .csv I used. Is it a problem because in the column H04, there is a variable with parentheses? For example: Pasta (excl spaghetti, macaroni) [Uploading cpi_prices_reformatted - cpi_prices.csv…]()

CiaranOtter commented 1 year ago

The parentheses shouldn't be a problem but the commas separating item inside the parentheses would be considered a separate item. I will try to find a way around this.