Lat./Lon to geometry

[Brain]

HI,
I am creating this workflow, which does not give any error messages initially. If I add the ‘math formula’ node, I get this error message :
“DataSpec generated by configure does not match spec after execution”
Why? Will this affect the geolocation?

Thanks
Br

[rfeigel]

Its impossible to understand your problem from a screenshot. Can you share your data and workflow?

[Brain]

Hi,
Here is the workflow largely inspired by the JKI S3 C3 (Real Estate) version concerning the French Basque coast.
I’m also trying to reproduce part of @mwiegand 's solution using BIN and Classify metrics to highlight the most expensive cities with colors, but I’m currently stuck.

IMMO 64.knwf (2.9 MB)

data 64 SAMPLE.xlsx (26.2 KB)

Thanks
Br

[rfeigel]

I corrected the first date in the input file which was in Excel number format. The workflow now runs. Could you explain in some detail what your issue is? “Currently stuck” doesn’t provide any useful information. Regarding the error message, I think its irrelevant. Read this post:

Lat/long to geometry showing error

Hello Mick, thanks for testing. We will investigate if we can prevent the KNIME nodes to use the environment variable (internal ticket number AP-19786). We are aware of the warning message. This message appears if the type of one of the column changes e.g. from int to double or Geo(Point) to Geo. Most of the time the data types are compatible e.g. int can be represented as double and Geo includes Geo(Point) and you can ignore this warning. We are working on improving the type handling logic in…