We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

EXCLUDING A SPECIFIC LINE

LETICIAHELENA
8 - Asteroid

hello all good?

 

How Can I exluce a specific line of my column ?

 

LETICIAHELENA_0-1680214990429.png

 

11 REPLIES 11
LETICIAHELENA
8 - Asteroid

as example above I want eliminane the line completely "aplic aut mais" 

Qiu
21 - Polaris
21 - Polaris

@LETICIAHELENA 
There is a filter tool, you can set the criteria to be !Contain([Texto], "aplic aut mais" )

LETICIAHELENA
8 - Asteroid

Thanks @Qiu Can you help with one more thing? I need to sumazire the amount below date by date where the S is my entries and H means outflow the bank account. Do you know how can I do that?

LETICIAHELENA_1-1680216313872.png

 

 

LETICIAHELENA
8 - Asteroid

also I need separate by column, creates 2 columns with one is S column and the other H column

martinding
13 - Pulsar

Hi @LETICIAHELENA ,

 

You can simply use a cross-tab tool:

martinding_0-1680217655550.png

 

Qiu
21 - Polaris
21 - Polaris

@LETICIAHELENA 
I will also do the same as @martinding 😁

LETICIAHELENA
8 - Asteroid

Thanks a Million

LETICIAHELENA
8 - Asteroid

And is it possible agroup by the date?  I need like just one line for 2023/03/24 with the total amount in "entrada" and " Saida" instead of 3 lines

LETICIAHELENA_1-1680227753503.png

 

 

LETICIAHELENA
8 - Asteroid

LETICIAHELENA_2-1680227785897.png

 

Labels
Top Solution Authors