Table of Contents | ||||
---|---|---|---|---|
|
...
How does it work in the search window?
Select Create column in the search window toolbar, then select the Floor operation. You need to specify one argument:
Argument | Data type |
---|---|
Number to round mandatory | integer, float |
The data type of the values in the new column is integer or float, depending on the selected input data.
Example
...
Rw ui textbox macro | ||
---|---|---|
| ||
The examples in this article use values in a data table generated from the following CSV file. |
...
If you want to try the example for yourself, download the file and upload it to your domain by clicking Data upload in the navigation |
...
panel. Name the new table After receiving the confirmation message, you can access the table from the Finder, selecting my → upload → sample → data. When you upload data from a file, all the information is included in a single column called message. To split the values into different columns, you can use |
...
the Split |
...
operation. Click Toggle Query Editor in the search window toolbar and paste the following LINQ query to save time:
|
In the my.upload.sample.data
table, we want to round down all the numbers in the decimals_float column. To do it, we will create a new column using the Floor operation.
The arguments needed to create the new column are:
Number to round - decimals_float column
...
Click Create column and you will see the following result:
...
Use the operator select
... as
... and add the operation syntax to create the new column. This is the syntax for the Floor operation:
floor(number)
Example
You can copy the following LINQ script and try the above example on the my.upload.sample.data
table.
Code Block |
---|
from my.upload.sample.data select split(message, ";", 16) as decimals select float(decimals) as decimals_float select floor(decimals_float) as decimals_floor |