Skip to Content

bods: what is the best way to check and replace each column value in each table

Jul 20, 2017 at 07:59 AM


avatar image

hi all,

we currently have 50 target tables in our project environment, this list will keep growing.

my requirement at the end of every dataflow is to do the below activity:

---- check in every table , every column value

----- if it is space , replace it by null

regular method : is to call the ifthenelse or replace function,.. for each column in query transform, but this will be an overhead task in terms of execution time , effort as well.

can anyone please suggest a simpler way to accomplish this task?



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Charity Cajigas Jul 31, 2017 at 01:47 PM

You may use SQL script for full pushdown. Let the database do the hard work!

10 |10000 characters needed characters left characters exceeded