Solved

Dynamic Variable Names

  • 17 April 2023
  • 2 replies
  • 105 views

Userlevel 4
Badge +10

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!

icon

Best answer by Eli_Shteinberg 18 April 2023, 16:28

View original

2 replies

Userlevel 2
Badge +4

Hey @bsikes ,

Unfortunately, we currently do not support the capability.
I would appreciate it if you could share the idea in our portal so we can consider the need for possible future support.

Userlevel 4
Badge +10

Thanks @Eli_Shteinberg , I’ll make sure to do that.

Reply