Problem with string and number

KNIME Analytics Platform
#1

hey :slight_smile: i have a problem with convert number stored as text to number knime. i used string to number but is not good idea because some of data convert into ?. thanks for helping

#2

Hi @pjacob

Welcome to the forum. Check if there is any whitespace before and/or after your text-number. If so, remove it. Hope this helps,

gr . Hans

#3

@HansS unfortunately i try this but not working :confused:

#4

@pjacob mmm Can you upload a simple KNIME workflow with the data table with some data that causes the problem?

1 Like
#5

I upload my data from google sheets and save my data as .csv

#6

with uploading I mean uploading a sample KNIME flow (File -> Export KNIME Workflow …) to the KNIME forum with some data that causes the problem , so the community can have look at this problem.
Knipsel

3 Likes
#7

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.