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