Alteryx Designer Desktop Discussions

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

Delete specific rows

qgpl
8 - Asteroid

Hello 

 

I need to delete "Available Funds" and the figure that comes below it, from the screenshot it's currently ****.** and as you can see I have "Balance" and it's figure right below it which I need in my output. 

 

qgpl_0-1676976468315.png

 

Throughout my data "Available Funds" disappears so it's a bit inconsistent. I have attached a sample data. 

 

My expected output (for example) is

 

COMPANY NAMECOMPANY ACCBALANCECCY
COMPANY LIMITED 1IE1235678910****.**EUR
COMPANY LIMITED 2IE32154987956****.**GBP

 

I'm nearly there... I just need to get rid of the Available Funds without removing any other data i.e. I need currency and account number to stay so I can't use the Filter function. 

 

qgpl_3-1676976913778.png

 

My workflow so far! I'm a complete beginner - please don't judge ðŸ˜…

qgpl_2-1676976654535.png

 

Thank you

 

5 REPLIES 5
ShankerV
17 - Castor

Hi @qgpl 

 

One way to remove with the help of Multi row formula.

 

ShankerV_0-1676978034718.png

 

qgpl
8 - Asteroid

Thanks so much @ShankerV  - what do I do if the available funds have figures in it not *?

 

qgpl_0-1676979213462.png

 

 

qgpl
8 - Asteroid

I replaced it with "." instead :)

ShankerV
17 - Castor

Hi @qgpl .

 

So what will the value in the input file instead of *

As I see the * in the input file, I have applied the logic.

 

Please replace with the character which is in your latest input file.

qgpl
8 - Asteroid

Thank you!

Labels
Top Solution Authors