Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

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

calvinwong
7 - 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!

1 REPLY 1
jdunkerley79
ACE Emeritus
ACE Emeritus

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