I'm not an expert and need your help in selecting the correct Node to pull results.
Please see the attached flow for visual.
Table A has a lot of data and it will not allow to run a select statement on ALL fields; I'm trying to use location_ID from 2727 output and join on location_ID in table A, so in that node I only get results for same locations as listed in 2727 output (like left outer join statement however these join statements do no allow to pull data from tables, just join on already pulled data)
Something like this:
select * from 2727set
left outer join Table A
on 2727set.location_ID = TableA.location_ID
Please note, I'm on 3.4.3 version of Data3Sixty.
Please sign in to leave a comment.