community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

How to Filter certain entity and show only the rows with numbers?

Highlighted
Meteor

Hi,

 

I have the following data:

 

LineDescriptionEntity1Entity2Entity3Entity4
1ABC3400
2BCD0000
3EFG2000
4HIJ0000
5KLM12060
6LMN0000
7MNO01900

 

I'm trying to use a dynamic select tool and other tool to select only the rows and entity with numbers. I can use a normal filter if it's just 1 entity. However, I'm not sure how to apply that to multiple entities and I don't want to select each Entity column everytime. Because sometimes, there will be a lot of entities.

 

The final result should look something like this:

LineDescriptionEntity1Entity2Entity3
1ABC340
3EFG200
5KLM1206
7MNO0190

 

Thanks for your help in advance!

I would suggest the following:

2018-12-08_07-26-07.png

1. Transpose the data so it is row based

2. Filter out cells with no data (assumed to be 0 in your example)

3. Create a set of line ids with some data

4. Join this back to original input to make set of rows with some data

5. Using the transposed set create a set of field names with some data

6. Use a dynamic rename to set the description for these fields then use this in a dynamic select to pick columns with data and combine with a chosen 'white-list'

Labels