We were hoping to make a Global Function that could take a variable with delimited headers and do the following:

1.  For each header, create a new variable that is named using this syntax: Header + “-ColNum”
2. Value for the variable would be equal to the column’s number, relative to the other other headers in the delimited variable. 

As an example, a delimited variable like this: “Account Number, Balance, Address”

Would result in the following variables:

• Account Number-ColNum
  • 1
• Balance-ColNum
  • 2
• Address-ColNum
  • 3

In future steps of the wizard, this would allow us to use the new variables in place of hardcoding the column values. This would also make it so that if the order of items changed in the delimited data, the Wizard would still work correctly since the global function would be determining where that particular column is in the data at runtime. 

Unfortunately, we can’t reference a variable in the variable name portion of the of the “Set a Variable” action.  Is there anyway to make variables dynamically, without hardcoding it’s name?

Thank you!