Cannot insert the value NULL into column

[Anonymous]

I am joining Excel data and DB table data using tMap with ID as key. With this, DB table has to pull couple of column's more with the help of Key to Output but i am getting below error. Please suggest.

Cannot insert the value NULL into column 'MRN', table 'XYZ'; column does not allow nulls. INSERT fails.

Actually there's no null value in DB table data, but its still showing cant insert null value in MRN

[manodwhb]

@samisyed80,filed length is doesn't matter,when you have matched data in soruce and lookup table.

[manodwhb]

@samisyed80,since your were data my not correct due to format,what kind of data it has in Id column in excel file?

[TRF]

By default, tMap use left outer join so if there is no matching row for a main row, MRN field will be null.
Use an inner join instead.

[Anonymous]

Sorry, i was pointing to wrong table. Issue has been resolved now. Thank you.