Change data type in DB GroupBy Node

[RocioPerez]

I am connected to an SQLite database, and I am using the DB GroupBy node to calculate the SUM, AVG, and COUNT of a double variable. When displaying the result, the variable type changes, and it shows all three results as string types.

[k10shetty1]

Hello @RocioPerez,

I found a thread saying “SQLite behaves very strange when it comes to types” here.

To resolve the issuey you will have to set the input mapping as per your requirement in the “DB Table Selector Node”. Here is an example of how you can do it if all your input numbers are integer :

Output before the mapping:

Output after the mapping:

Hope this helps.

Best,
Keerthan