Converting values by formula

cruonit

What is to easiest way to convert a value like fahrenheit to celsius (i am experimenting with the GOLF dataset) with the formula: (°F - 32) * 5/9 = °C

And also for dates is there a tool for conversion form one format to another - from CSV to mysql format  ect. ?

MariusHelf

Hi,

for calculating formulas you can use the Generate Attributes operator.

To convert data between different formats (csv/excel/sql) just load the data with the corresponing Read operator (e.g. Read CSV) and then write it with one of the write operators into the desired format (e.g. Write Database).

Best regards,
Marius