Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
Column is not present in the transform tab , but getting the error. "Null value in a non-null column".
When checked in the target db , the column is present.
could you please help on this.
Source - SAP hana
Target - Azure SQL
Thanks
Hi @suvbin ,
Thanks for reaching out to Qlik community.
I would request you to provide more information on the issue, like error message and the column name ,etc
Regards
Arun
No its not complaining regarding the the column exist in the target or not. Its throwing error stating "cannot insert tbe value NULL into <column>, <table>.<column> does not allow null"
hello @suvbin
IN such cases you have to look into to table metadata and particular column. As QR is apply the Statement onto the Connecting database and such constraints are managed by database itself
if column is marked as not null then during insert or update you have to put some value in it , otherwise your insert statement fails. or Allow null value then you statement will succeed.
Regards,
Sushil Kumar