Is it possible to remove columns after a table?

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?

TestWorkflow-r1.yxmd

Workflow

Accepted answers

All comments

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/972401

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

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703