Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
SOLVED

Create a column based on another

Highlighted
7 - Meteor

Problem.PNG

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

If seems like the basic idea of the 'YEAR' field is determined by the 'PAY ELEMENT' field begins with "FY". If it does begin with "FY", take the first 4 characters. When it does not, should you take the year from the previous row? What if the first row of 'PAY ELEMENT' doesn't begin with "FY"?

 

Anyways, I've attached a quick example using a Multi-Row Formula tool. 

Highlighted
7 - Meteor

Thank you 🙂

Highlighted
7 - Meteor

Hello there, 

 

is there a way to add "FTE" & "CURRENT_BASE" to every year? it is basically what you asked before (What if the first row of 'PAY ELEMENT' doesn't begin with "FY"?)

Please advise. Thank you in advance!!

 

 

X.PNG

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

The rows can be forced in, but how would you like to populate the "AMMOUNT" field? I imagine there would be rules to that.

Highlighted
7 - Meteor

Hi Charlie,

 

Actually, there is a slight change on how the desire outcome should look like. Please see below

Not sure if I have to create a table for every year then combine/join them..this would be my issue.

Thank you in advance for your help!!

x.PNG