Column should be available in case of satisfaction of condition

[ferha_jafri]

Hello Experts,

I have a requirement in which the column should be available when it has value in the output through render tool. In the attached excel I have attached the output as well which will be generated by group by ID in the render tool. The issue is I do not want the data generated corresponding to Null.

[atcodedog05]

Hi @ferha_jafri 

Why not just filter null before passing through output tool or before passing through table tool.

Maybe there is much more to the issue 🤔

Hope this helps : )

[ferha_jafri]

It has more data and due to which I could not filter it out.

[atcodedog05]

Hi @ferha_jafri 

Is it like you need to check whether all columns are null or either column is null?

[ferha_jafri]

Basically I have a requirement in which I have to include the Value column when it has value if it has null I do not to include it in the output file.

[atcodedog05]

Hi @ferha_jafri 

Is it a single value column or multiple value columns? And why wouldn't filter work? just trying to get a better understanding 🙂

[ferha_jafri]

It has multiple values, my requirement is that Value column appear in the output if it has value otherwise it should not appear and if I apply filter it will break the complete data set, although I want the whole data set.