ALL FEATURE REQUESTS HERE ARE MONITORED BY OUR PRODUCT TEAM.

VOTING MATTERS!

IDEAS WITH HIGH NUMBERS OF VOTES (USUALLY ≥ 10) ARE PRIORITIZED IN OUR ROADMAP.

NOTE: IF YOU WISH TO SUGGEST A NEW FEATURE, PLEASE POST A NEW QUESTION AND TAG AS "FEATURE REQUEST". THANK YOU.

How to import CSV files with attributes values containing % character?

vgpoweredvgpowered MemberPosts:16Contributor II
edited March 2020 inProduct Ideas
Is there a way to import attribute values with the percentage character %?
or how to convert a polynominal value like 90.5% to 0.905?
Tagged:
(删除用户)
1
Up
1 votes

Open for Voting·Last Updated

PROD-926

Comments

  • kaymankayman MemberPosts:662Unicorn
    You can use the generate operator for this. You strip the % sign, then parse it so it becomes numeral and divide by 100 to get your final value.

    Sounds more complex than needed, it's like in below example :


  • sgenzersgenzer Administrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM ModeratorPosts:2,959Community Manager
    fascinating. Parse Numbers should do this but it does not. Pushing this to feature request.
Sign InorRegisterto comment.