Append Fields

Question

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

Input:

CountAmountTOTAL CASH ADV3,6781,627,781.08TOT GROSS SALES1,107,85894,289,705.50CREDIT VOUCHERS29,3743,773,964.10

Desired Output:

ValueTotal Cash ADV_Count3,678Total Cash ADV_Amount1,627,781.08TOT GROSS SALES_Count1,107,858TOT GROSS SALES_Amount94,289,705.50CREDIT VOUCHERS_Count29,374CREDIT VOUCHERS_Amount3,773,964.10

thanks!

vizAlter · Accepted Answer

Hi @jenner85 — Try this solution:

cgoodman · Accepted Answer

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