nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Is there a way for me to remove other column that is not part to that sheet/ tab?

abardaje

Would like to remove some columns that is not really part of that sheet/tab it appears to other tab because I used the 'Group by' in Table tools. Let me know if there's a tool that I can use after the table tool for me to remove some columns that is not part of that sheet/tab in Excel.

Output

Tips and Tricks

Help

Accepted answers

All comments

vlad_kutateladze

@abardaje you can use the Select tool after the Table tool.

abardaje

Hi, this is the displayed here in the results - table. so, In Select Tool, how can I remove some column there that won't affect that column to another sheet/tab?

vlad_kutateladze

@abardaje Not very clear to me. Field 'Credit Ratings ' is an extra column after the Table tool, but after it is used in Text tool. so what column do you want to remove?

DataNath

@abardaje I'm not aware of any way of doing this and using a select after the table tool won't work as the table is now a reporting snippet. It's not very elegant but it may be the case that you have to just filter out your dataset into the 'Group by' sections you want, create a different table for each containing only the desired fields and then union the tables together before rendering. If there's a better way of doing this within the Table tool itself I'd love to see though so hoping someone else can jump in!

abardaje

Please see the sample below after I used the 'Group by' in Table tool. So, what I want is to remove column that is blank/s in each sheet/tab.

sample for this case.xlsx

Christina_H

If you need different columns in the table each time, you can do this with a batch macro, see attached. The macro input only knows about the grouping field, and I use a trick from here to any remove null columns:

Solved: Automatically Remove all null Colums - Alteryx Community

(This won't work correctly if you have Boolean columns you need to include)

The correct columns then get included in the table through "Dynamic or Unknown Fields"

Tables no nulls.yxzp

abardaje

Would like to use your solution however we don't have batch macro tool yet in my Alteryx as of this moment.

Christina_H

@abardaje

The batch macro isn't a separate tool, it's a different workflow used as a sub-routine. The one I created is included in the package on my previous reply, you should be able to use it as it is or modify it to meet your needs. Right click on the blue circle and select Open Macro to make changes to it.

Feel free to ask more questions to get it working, I can't think of any other way to achieve what you want without splitting out all the different possibilities to different table tools.

abardaje

Already found the best solution for my problem I used Formula tool and there create another column for if else condition and that new column will separate based on the logic I did. Thank you for all your help!

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15908

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703