In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

return value, different length

tiverson
8 - Asteroid

Trying to return values from original list, without the [-] 510S_ items or the 510S_

The PC Group column is what I am trying to come up with

tiverson_1-1645117366980.png

 

11 REPLIES 11
atcodedog05
22 - Nova
22 - Nova

Hi @tiverson 

 

Really sorry I know in excel you are considering based on [-] symbol on which to not extract. But since this is not appearing in Alteryx input data it's hard to apply any logic. If you find that it's following a specific pattern let me know.

 

Hope this helps : )

tiverson
8 - Asteroid

I agree, I am using a report that we download from another source and when we try to input the file the [-] disappears.  I can only get it to show up when I copy and paste the original file into a text input.

I appreciate your help.

 

Thanks

 

Labels
Top Solution Authors