community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Multiplying fields based on unique names

Meteor

Hello to the community,

 

I want to multiply fields from different source documents based on the field names being identicle, i.e. see attached:

 

So multiply 'person 1' hourly rate by 'person 1' number of hours worked, to create a new field 'Employee Cost' for person 1, person 2, etc. per month.

This is just a simple example representing what I am trying to do, there are 100s of fields in my data . What is important is that the multiplication only takes place if the names are identical. 

 

Join doesn't work because it renames the field names which are not unique - anyone have a possible solution?   

Alteryx Certified Partner
Alteryx Certified Partner

Hi @Alastair

Did you try to transpose the fields before using the join?

 

Meteor

 


@aguisande wrote:

Hi @Alastair

Did you try to transpose the fields before using the join?

 


Hi @aguisande, that sounds like the right approach.

 

So once I have transposed, I can join by the persons name, then I can create a new field for employee cost [$ * $/hr]. But now I have 2 dates fields with different dates per record - how would you then suggest grouping by common dates?

Meteor

I can join by name and date within the same same join and then it works well. Thanks for the suggestion.

Labels