data not loading from db table

[shalinim1]

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?

[manodwhb · Accepted solution]

@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

[manodwhb]

@Shalini M​ , you see in your screenshot it was loading 100 records to tDBoutput right?

[shalinim1]

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.

[manodwhb]

@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

[shalinim1]

@Manohar B​ Thanks a lot! It worked! 😊

Regards,

Shalini

[manodwhb]

@Shalini M​ ,Great that you issue is fixed 😊