csv ot geom

Hello @pbiffar​ 

If I understood your doubt, you want to read a CSV file and extract lat and long, by last geospatial these points, correct?

If yes, you can use the transformer VertexCreator to Replace with Point.

Thanks,

Danilo

take the csv lat lon and create point geom, I think I found that it does that automatically?

Here is a more complex question.

I have csv A and csv B of the same data columns. Let's say A is from July issue of data and B is August issue date. Some of the data is the same in both, some is updated, some is new in B, some is in A but not in B

Assume data has a unique id numbers.

Is there one or a combination of transformers which identify.

• what rows are in A but not in B
• what rows are in B not in A
• what is identical in A and B
• what rows have changed in A versus B, ideally which fields of the row have changed

Hi @pbiffar​ , as @danilo_fme​  suggested, you can use the VertexCreator to create a point from the two column values - lat and lon.

Alternatively you can also create a point geometry directly from the two column values for each record if you specify attribute types "x_coord" and "y_coord" for the two columns through the reader parameters dialog when adding the CSV reader, as in:

Regarding the second question, the ChangeDetector transformer might help you.

Thanks @Takashi Iijima​ to endorse the answer :)