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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We'll be doing maintenance between 9am-11am MT on Saturday, January 25th, which may impact your experience. Thanks for your patience as we work on improving the community!
SOLVED

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

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