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