Suppress Rows tool in Alteryx

[rohit782192]

Hi ,

How can we do a Supress row tool in Alteryx. Can we have an Example.

[gawa]

hi @rohit782192 Can I ask what does "suppress row" imply? In terms of reducing records, we already have Filter tool, Unique tools, etc.

Or, is it a kind of Generate Row tool which will reduce the rows by conditional & decremental statement?(I know nothing about it though)

[caltang]

You mean dropping columns/rows when there is no daata or a pre-determined insignificant amount of data? You'll need to pivot your data accordingly with the Transpose and Cross-Tab tools if I understand you correctly. Not sure if there's a tool just for that. Would be a cool macro for sure.

[rohit782192]

Yes