Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
darrellbutler
Creator
Creator
‎2012-03-20 01:11 PM

Import Wizard not Recognising delimiter

Hi I have a csv file that has data in the format of "TONBASE","300", "SITE", "CASD" when importing the file QV recognises it as being comma delimited but only includes the first column and discounts all the others.

Is the only way around this to make it a Fixed Record import ?

Many thanks

Darrell.

453 Views
0 Likes
1 Reply
erichshiino
Partner - Master
Partner - Master
‎2012-03-20 02:37 PM

Hi, Darrell.

Maybe you need to try different 'quote' settings.

Can you post a data sample and the script you generated with the wizard? It can make easier for the community to help you out

Regards,

Erich

251 Views
0 Likes