Append Fields

[jenner85]

Hi - how do I append fields in the following way:

Input:

	Count	Amount
TOTAL CASH ADV	3,678	1,627,781.08
TOT GROSS SALES	1,107,858	94,289,705.50
CREDIT VOUCHERS	29,374	3,773,964.10

Desired Output:

	Value
Total Cash ADV_Count	3,678
Total Cash ADV_Amount	1,627,781.08
TOT GROSS SALES_Count	1,107,858
TOT GROSS SALES_Amount	94,289,705.50
CREDIT VOUCHERS_Count	29,374
CREDIT VOUCHERS_Amount	3,773,964.10

thanks!

[vizAlter · Accepted solution]

Hi @jenner85 — Try this solution:

[ImadZidan]

Hello @jenner85 ,

Have a look at the workflow. it will give you an idea.

Any problems, give us a shout

[cgoodman3 · Accepted solution]

Hi @jenner85 

This is how you do it, the bit you need is a transpose tool to pivot the headers down into a new field and then use a formula tool to update the name.

I've gone one step further to convert the numbers into a numeric field type which means you can add the numbers up, which you can't do with a string field type.

Chris