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 , you see in your screenshot it was loading 100 records to tDBoutput right?
Yes, but the part_name column was null except 3 rows. if all the record in row3 would load. then there will not be any null column.
@Shalini M ,which means there is no matching records from row3 lookup based on partid, because of it it was giving null column values.
Thanks,
Manohar
@Manohar B Thanks a lot! It worked! 😊
Regards,
Shalini
@Shalini M ,Great that you issue is fixed 😊