Excel - Pivot multiple columns of data and compare data

[bradaba33]

Hello - 

I am trying to create a workflow to accomplish the following - compare Test 1 q1 data with Test 2 q4 data, presented as follows: 

1. Column A = Location

2. Column B = Location Code

3. Column C = Code currently housed in row 13 (example - C001000, C004000, etc.)

4. Column D = State filing method from "Test 1 q1" file

5. Column E = State Provision Current Calculation from "Test 1 q1" file

6. Column F = State Provision Deferred Calculation from "Test 1 q1" file

7. Column G = State filing method from "Test 2 q4" file

8. Column H = State Provision Current Calculation from "Test 2 q4" file

9. Column I = State Provision Deferred Calculation from "Test 2 q4" file

[FrederikE]

Hey @bradaba33, 

I am not 100% sure what you do want to compare with each other. But with the dataprep in the attached WF it should be easy to do.

But if possible you may want to look into where the input file is generated - idk why somebody would do something like that...

[PangHC · Accepted solution]

@FrederikE I suggest you can try to learn more on dynamic rename and field info.

these 2 tools are helpful when manipulate the Field name.

Tool Mastery | Dynamic Rename - Alteryx Community attribution dynamique d'un nouveau nom dynamisch u...