Question Re: Query transftorm where clause in Technology Q&A

Query transftorm where clause

Former Member — Sun, 25 Feb 2018 15:43:35 GMT

hi guys

In bods query transform i m trying to write a where clause to filter on a material number. I am able to filter one material number but how can i filter on multiple material numbers. Syntax i m using is

TABLE1.MATERIAL = '10001234'

Re: Query transftorm where clause

former_member187605 — Sun, 25 Feb 2018 21:59:56 GMT

Use IN or OR:

TABLE1.MATERIAL in (‘A’,’B’)
TABLE1.MATERIAL = ‘A’ or TABLE1.MATERIAL = ‘B’

Re: Query transftorm where clause

Former Member — Mon, 26 Feb 2018 08:48:50 GMT

thanks Dirk.. i know that was very elementary but i am new to it. Appreciate your help.