Alteryx Designer Desktop Discussions

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

Filling Null row with Data and update with below columns

shivanand612
7 - Meteor

Hi All,

 

I would like to change my Header dynamically and below is my problem statement and the result that i am looking for 

 

Problem Statement 

1nullnullnullnullSalesnullnullSales 2nullnullSales 3nullnull
2CountryStateRegionCityTargetAchieved% AchievedTargetAchieved% AchievedTargetAchieved% Achieved

 

Result i am looking 

CountryStateRegionCitySales TargetSales AchievedSales % AchievedSales2 TargetSales2  AchievedSales2  % AchievedSales3 TargetSales3 AchievedSales3 % Achieved

 

Thank you 

3 REPLIES 3
AndrewDMerrill
13 - Pulsar

Here is a sample workflow that achieves your stated goal:

Screenshot.png

Qiu
20 - Arcturus
20 - Arcturus

@shivanand612 
I believe you should also have data rows after these headers.

I made a slight change based on @AndrewDMerrill flow.

1203-shivanand612.png

shivanand612
7 - Meteor

Thank You 

Labels