Postgres Row Lookup: Need Help with Output Column for Filtering

·

Hey team, I'm running a postgres row lookup column and I need it to output a result column that I can use to filter the rest of my table. Right now there doesn't seem to be any output column variables available. Any insight on this?

8 comments

Bruno R.
·
·
Hi Clark, thanks for reaching out. Do you mind sending the link to the table so we can take a look? https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1730991600&signature=f942949e9185af048282743da8ed995c12bb80d433d3c5993c34189a819c2a38&req=dSEgF85%2FmohWX%2FMW1HO4zYTywSv1D5YQ2BKsam%2FhVPsZ8Q%3D%3D%0A
Clark G.
·
·
https://app.clay.com/workspaces/369580/tables/t_adhmacZdt8CP/views/gv_Pc2gQt7JKCs6
Bruno R.
·
·
Looks like this sql query is not returning any values. Can you try running this sample query in postgres (it simulates the query for row 1) and see if you're able to return any records? SELECT * FROM "User" u WHERE (u."email" = 'ayush@syntra.com' OR u."linkedinUrl" = 'https://www.linkedin.com/in/ayushjain04') AND (u."email" IS NOT NULL AND u."email" <> '' OR u."linkedinUrl" IS NOT NULL AND u."linkedinUrl" <> '') LIMIT 1;
Clark G.
·
·
I'll try that, but to clarify, there shoudn't be many results in general. You can see in the original screenshot 1 returned found out of most.
Bruno R.
·
·
I see sorry about the confusion here Clark, the issue you're having is related to parsing out the json object's arrays into individual columns here, I recorded a quick video to show you how you may be able to do this, but let me know if I'm still missing context on the error here: https://www.loom.com/share/ad27234dd1cf42e78a3708b85374bdc7?sid=2d963913-1cac-491e-b49a-0ff62e92eaa5
Clark G.
·
·
Amazing! Thanks for your help!
Bruno R.
·
·
Happy to help here Clark!
Channeled
APP
·
·
Hi Clark G.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: