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
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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: 
Anonymous
Not applicable
‎2017-05-23 06:42 AM

CSV column custom parser

I would like to import numeric columns from CSV file in custom format. One column has "#N/A" when value is not available, while other contains percentages and have "%" at the end.

 

Labels (2)
Labels
280 Views
0 Likes
1 Solution

Accepted Solutions
TRF
Champion II
Champion II
‎2017-05-23 06:55 AM

So datatype in the CSV schema must be string and you have to convert by yourself.

View solution in original post

280 Views
0 Likes
3 Replies
TRF
Champion II
Champion II
‎2017-05-23 06:55 AM

So datatype in the CSV schema must be string and you have to convert by yourself.

281 Views
0 Likes
Anonymous
Not applicable
‎2017-05-24 02:54 AM
Author

I was afraid that somebody would say that 0683p000009MACn.png
Thank you! I did it with mapper and some custom routines.

280 Views
0 Likes
Anonymous
Not applicable
‎2017-05-24 05:40 AM
Author

Can you please post the customization mapping so it will be helpful  for others.

 

Regards,

Nagaraju Adapala 

280 Views
0 Likes