Converting values by formula
cruonit
New Altair Community Member
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. ?
And also for dates is there a tool for conversion form one format to another - from CSV to mysql format ect. ?
Tagged:
0
Answers
-
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,
Marius0