c_decoster
New Contributor
Joined 4 years ago
User Profile
User Widgets
Contributions
Postgresql Execute doesn't show the result (SELECT query)
Hello, I'm trying to do a complexe PostgreSQL SELECT so i'm trying to use the Execute snap. (here is the snap settings : ) We can see in the pipeline execution statistics that he found the result i need (when i do this query in pgadmin i have the same amount of row (990)). But i can't gather the data, neither in the pre-view, or in a mapper. What can i do to get the data i need ? Thanks in advance, Decoster CorentinPostgresql Lookup on a float value
Hello, I have a lookup snap that verify if a specific data exist in a specific table. The type of the column is a float. When I do the lookup : and when I verify that the value (here “2”) exist in the column named “value” the lookup return me false. I guess it’s data type missmatch but I use the parseFloat method to get the matched data type. What is the problem here? the database contains the value (image 1) and the output of the lookup condition value is 2 (image 2). I verified that the name of the table and the column exist, that the value is in the DB. Thanks, Corentin
