Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 3 input database tables which is connected to tmap. While running the job, the whole data from main and 1 lookup are loading. And from another lookup only 2 rows are loading. How to get the whole data?
@Shalini M , if your getting 2 records then row4 has only four records or some where you were filtering the query to get only 2 records?
other if you want get all records from row3 make row3 as main.
Thanks,
Manohar
@Shalini M , can you show tmap settings and do the leftouter join lookup.
Thanks,
Manohar
@Manohar B Please find the screenshot. row3 lookup is not loading as a whole data.
Regards,
Shalini
@Shalini M ,row2,how many records coming?
@Shalini M , there is only two records matching from main and the lookup which is giving 2 records.
Thanks,
Manohar
100 records
@Manohar B Then how can I get the whole record from that table?
@Shalini M , Are you sure the which table is main? I believe you need to make row4 as main and row2 first lookup and row3 second lookup.then you will get the all records from row4 and which all vendor ids.
Thanks,
Manohar
Okay! will try in that way!
Regards,
Shalini
@Manohar B Still loading only 2 rows.