topic Re: An issue with .csv file upload in QlikView

An issue with .csv file upload

Peony — Wed, 25 Nov 2020 16:16:04 GMT

I've create .csv file with come data (example is below). When I Load this file into the "edit script" the 2-nd and 11th item still stay as string without separating into the columns.

How can I to separate the rows into columns while loading?

Product_Id,Product_Line,Product_category,Product_Subcategory

1,Sporting Goods,Outdoor Recreation,Winter Sports & Activities

2,"Food, Beverages & Tobacco",Food Items,Fruits & Vegetables

3,Apparel & Accessories,Clothing,Uniforms

4,Sporting Goods,Athletics,Rugby

5,Health & Beauty,Personal Care

6,Arts & Entertainment,Hobbies & Creative Arts,Musical Instruments

7,Arts & Entertainment,Hobbies & Creative Arts,Orchestra Accessories

8,Arts & Entertainment,Hobbies & Creative Arts,Crafting Materials

9,Hardware,Tool Accessories,Power Tool Batteries

10,Home & Garden,Bathroom Accessories,Bath Caddies

11,"Food, Beverages & Tobacco",Food Items,Frozen Vegetables

12,Home & Garden,Lawn & Garden,Power Equipment

Re: An issue with .csv file upload

Sergey_Shuklin — Mon, 30 Oct 2017 16:32:10 GMT

Добрый день, Наталья!

Попробовал загрузить Ваш пример из txt - всё хорошо разделяется на колонки. Возможно, в исходном файле есть какой-то скрытый символ, который мешает разделителю. У Вас есть возможность выложить кусочек оригинального файла (с искаженными данными)? Спасибо.

Hello, Nataliia!

I've tried to load you example from txt, and it's work well. May be there is some technical symbol in that rows. Can you please provide a sample of original scrambled data if it's possible? Thank you!

Re: An issue with .csv file upload

vishsaggi — Mon, 30 Oct 2017 16:51:43 GMT

Strange it works find at our end. Can you share you sample csv file.

Re: An issue with .csv file upload

Peony — Tue, 31 Oct 2017 07:50:41 GMT

Доброго дня, Сергей.

Добавила файл к теме.

Re: An issue with .csv file upload

Peony — Tue, 31 Oct 2017 07:53:49 GMT

Hello, Vishwarath.
I have already add an csv example to the topic.

Re: An issue with .csv file upload

rubenmarin — Tue, 31 Oct 2017 08:51:44 GMT

Hi Nataliia, the rows that fails have this content:

"2,""Food, Beverages & Tobacco"",Food Items,Fruits & Vegetables"

The comma that should separate the fields is inside the double quotes, so QV reads this as part of the first field, it should be:

2,"Food, Beverages & Tobacco","Food Items,Fruits & Vegetables"

"2","Food, Beverages & Tobacco","Food Items,Fruits & Vegetables"

Re: An issue with .csv file upload

Peony — Tue, 31 Oct 2017 10:27:33 GMT

Can you say, how to definde that there is double quotes in the string, 'cause I see only 11,"Food, Beverages & Tobacco",Food Items,Frozen Vegetables

Re: An issue with .csv file upload

rubenmarin — Tue, 31 Oct 2017 11:37:43 GMT

Hi Nataliia, do right-click in the file and open it with notepad or any other text editor to see the real content.

Maybe you are openeing this in excel or any other software changes it.

Re: An issue with .csv file upload

vishsaggi — Tue, 31 Oct 2017 14:46:18 GMT

As ruben mentioned if you open it with notepad you see those extra quotes around 2 and 11 rows. Just remove them and it would work fine.

Re: An issue with .csv file upload

Peony — Wed, 01 Nov 2017 07:55:14 GMT

O! Indeed! Thank you, now it's obvious.

Re: An issue with .csv file upload

Peony — Wed, 01 Nov 2017 07:56:08 GMT

Thank you! It really helps.