Skip to Content
S N

Same column in all tables

Hi Experts,

I have one column called 'deleted flag' in all tables which needs to be = 0 for the reports.

How can I implement it on IDT as I want to include above condition for only those tables which are included in select statement.

I know creating mandatory filter will be a option but I just want those which are in select statement.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jun 19, 2017 at 03:32 PM

    Hi S N,

    You need to create a self restricting join, I had to do this in my previous project. In the DFX, right click on that column deleted_flag -> select Insert Filter -> in the window that opens up, update the expression as <Tablename>.deleted_flag = 0 and click OK. Repeat this for all the tables.

    Thanks,
    Mahboob Mohammed

    Add comment
    10|10000 characters needed characters exceeded