DSXchange

Can you perhaps explain exactly which stage and what columns you have? Are AAAAA, BBBBB, CCCCC column names? ... These are not column names... AAAAA, BBBBB are the values as part my test input data stream...i am trying to build a dynamic WHERE clause in transformer stage...this WHERE clause will be...

Hi all, My input: AAAAA = 10000 OR AAAAA = 10000 AND BBBBB = 20000 AND CCCCC = 20000 OR CCCCC=20000 AND DDDDD=30000 Output should be: (AAAAA = 10000 OR AAAAA = 10000) AND (BBBBB = 20000) AND (CCCCC = 20000 OR CCCCC=20000) AND (DDDDD=30000) basically all the ORs should be grouped and put into braces ...

Hi all, My input: AAAAA = 10000 OR AAAAA = 10000 AND BBBBB = 20000 AND CCCCC = 20000 OR CCCCC=20000 AND DDDDD=30000 Output should be: (AAAAA = 10000 OR AAAAA = 10000) AND (BBBBB = 20000) AND (CCCCC = 20000 OR CCCCC=20000) AND (DDDDD=30000) basically all the ORs should be grouped and put into braces ...