Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Replace blank columns with the next non-blank value

janani_venkat
7 - Meteor

Hi All,

 

Attached is a sample excel data along with how I need this manipulated in Alteryx - can you please give me an idea on how I can achieve this? 

 

The data that I have only has details at total level but I need this to repeat every line (similar to "repeat line" option in excel pivot). Can you please help?

 

Thanks,

Jan

2 REPLIES 2
clmc9601
13 - Pulsar
13 - Pulsar

Hi @janani_venkat,

 

Would this work?

 

Screen Shot 2021-03-06 at 10.11.48 AM.png I hope it helps!

janani_venkat
7 - Meteor

@clmc9601 This is perfect - I just had to make some tiny tweaks but this gave me the idea! Thank you so much!!! Appreciate your help

 

Jan

Labels