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

Dynamic replace of row value, for other value in the same row

sebasgj
7 - Meteor

Hello,

 

I want to transform sheet1 into sheet2 (excel attached), I first input the file and tell it to read from row 5, next I want to populate the zeros with the brand name and I want to add the "Metric" Name below the Brand (these two is where I am having trouble) and then transform the data into a table grouped by metric, brand and date (which I already know how to do it)

 

Can someone help me with the part that I am having trouble please?

 

Thank you

 

 

5 REPLIES 5
BenMoss
ACE Emeritus
ACE Emeritus

The sample tool (or select record tool) alongside the transpose tool is your friend here.

 

Check out this solution.

 

Solution.png

 

Ben

LordNeilLord
15 - Aurora

Hey @sebasgj

 

Something like this should work for you:

 

Mrxslx.PNG

ponraj
13 - Pulsar

Attaching a sample workflow...Input.PNGoutput.PNG

sebasgj
7 - Meteor

Hello,

 

I applied your solution, but I am not getting every Value = 0, to the applied formula, am I making something wrong?

 

I attach the file 

 

Thank you

sebasgj
7 - Meteor

I found the error, np

Labels