I'm using TIS 3.0.4. I've created a SQL query to join the information from 2 tables and I'd like to feed the results to a tMap. I could use the lookup function, but it loads a couple of million rows from the lookup table and my query works much more quickly. How do I take the output from the query and use it for further processing? Using it as a tPostgresqlInput doesn't seem to work.
Re: [resolved] How to use SQL query as input to TMap
I created a qwuery to pull data from 2 tables: appointments and vehicles. When I pull the query into a job and as a tPostgesqlInput I'm not seeing the fields from the query. It's using the definitions from the first table listed in the Mavmail schema - account_manager_associations.