I have 2 Standard Data Extensions and an automation written to get values from one DE to other. The issue I am facing is Boolean values from one DE is not copying exactly in the other DE. False values are being shown as null. I am using * to fetch all fields in the query activity in automation and number of fields in both the DE are same.

This is image of the source DE

enter image description here

This is image of the target DE enter image description here

  • Can you please also share the SQL query you used, so that it will be helpful for the community to debug the issue easier. Jul 3, 2020 at 5:24
  • @VishalKumarCV I am just using steric to get all feilds from Data Extension. Jul 3, 2020 at 6:23

1 Answer 1


I found the solution and that is to explicitly mention all of the fields in the Data extension. It is working fine for me.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .