Skip to Content
avatar image
Former Member

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

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?

Regards,

Swetha

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jul 31, 2017 at 01:47 PM

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

    Add comment
    10|10000 characters needed characters exceeded