Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Peony
Creator II
Creator II

An issue with .csv file upload

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
1 Solution

Accepted Solutions
rubenmarin

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.

View solution in original post

10 Replies
Sergey_Shuklin
Specialist
Specialist

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

Попробовал загрузить Ваш пример из 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!

vishsaggi
Champion III
Champion III

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

Peony
Creator II
Creator II
Author

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

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

Peony
Creator II
Creator II
Author

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

rubenmarin

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"

or

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

Peony
Creator II
Creator II
Author

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

rubenmarin

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.

vishsaggi
Champion III
Champion III

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.

Capture.PNG

Peony
Creator II
Creator II
Author

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