Is it possible to remove columns after a table?

[MWon]

Hello All,

I currently have a workflow that, at the end, has a table that groups some data by manager. Right now, the table looks like this

I want to remove users who do not have any entries in their column. Is it possible to do this after the table has rendered it out, or would I have to manipulate it beforehand? 

[Luke_C]

Hi @MWon 

Apologies if this is a different question or use case, but the macro solution I provided in the below thread would seem to do that, no? If something isn't working or you need further clarification please let me know. 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Question-about-batch-macro-input/td-p/...

[MWon]

Hi!  I've been having trouble with getting macros to work, since I'm not too familiar with them. I wanted to see if there was a workaround to not using macros, hence why I made this post.

[Luke_C]

Once the table is created I'm not sure there's a way to do what you're asking. What problems are you having with macros? I'm sure we can get to the bottom of it. 

[ericsundby]

Can you give us an example of what you would like the end output to look like? Maybe a screenshot from Excel. I just want to make sure I'm understanding what you're trying to accomplish.

[MWon]

It starts like this, with the table outputting a number of tables like this, some of which have empty columns 

Curriculum	User1	User2	User3	User4
Curriculum1	x
Curriculum2		x
Curriculum3			x

And ends like this, where the empty columns are removed 

Curriculum	User1	User2	User3
Curriculum1	x
Curriculum2		x
Curriculum3			x

[rstowe]

I am thinking the OP is referencing a basic table tool that has a group by field associated. upon exiting the tool there seems to be no way to remove null columns.

[jrlindem]

<All you other advanced users, just close your eyes and ignore this post (j/k)>

I mean... you could just use the highly controversial Cleanse Tool before the render/report tool.... 😅

Cheers, - Jay

[rstowe]

Doesn't work if you're dynamically creating tables with the group by section of the tool. 

if you have multiple values in the column that is being grouped by. The output of the basic tool will generate multiple tables, as expected. Unfortunately, the output of the results keep all columns whether they have a value or not instead of dynamically removing columns that do not pertain to the specific grouping.