Importing from Google sheets - all as a string

Hi there

A knime newbie here but I love the product

I am importing data from Google sheets. When the data is imported, the columns become strings, and it is impossible to do anything with the data (eg convert string to number)

Wondered if there was some advice to be able to import numerical / date data from Google sheets and being able to transform it

Many thanks!

Hi @Kiwihammers

Welcome to the forum! Do you happen to have an (dummy) example/screenshot/workflow to see what you have going on?

KNIME has some tools for this, for example the String to Number node or the Table Manipulator that can convert data types.

1 Like

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