Dynamic Transpose in macro

[nagols5445]

Hello,

I am building an iterative macro that will take in the two files (FileA, FileB) and compare them on a key.  The file details are listed in a spreadsheet so I can have multiple rows of files.  For example: row 1 will compare c:\FileA and c:\FileB; row2 will compare c:\FileC and c:\FileD.  Once inside the macro I want to transpose the data based on a key.  The key is a column in the file.  When I transpose, the DataFields will transpose to a Name and Value.  The Key Fields is not working.  I have tried to update the @expression and then checked Replace a specific string.  I also tried to Replace Raw XML with Formula.  Unfortunately I cannot share the worrkflow or share a screenshot.  Hoping my issue is clear and you smart people can help.  Thanks.

[KGT]

What is not working?

Are the fields not being selected?

Do the key fields change? 

Is everything transposing to 2 columns (Name;Value) and you want more?

[Qiu]

@nagols5445 
We do need more details and I can not see the snapshot you mentioned.

[DawnDuong]

hi @nagols5445 

Fully understand that you cannot share the actual workflow and actual screenshot. But the question is not clear unfortunately.

How about creating a dummy data (which can dummy values) to illustrate (i) what inputs look like, (ii) what user interface items are required and (iii) expected outcomes? This way the community can help you more effectively.
Dawn.