Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

fill "up" the value

Jes_Li
7 - Meteor

Hi,

 

A quick question, is there a way to fill "up" the value like I have below data:

 

 a20
 b30
 c40
CashTotal90
 d200
 e0
Non-cashTotal200

 

And I want to fill the empty becoming this:

Casha20
Cashb30
Cashc40
CashTotal90
Non-cashd200
Non-cashe0
Non-cashTotal200

 

Thanks.

2 REPLIES 2
Jonathan-Sherman
15 - Aurora
15 - Aurora

Hi @Jes_Li,

 

I've attached my solution!

 

image.png

 

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

 

Regards,

Jonathan

Labels
Top Solution Authors