This is a tricky one - anyone up4it?
I have done this by multiple assign, but as the XLS grows I had the idea to take Column-1 (variable) on the left side of the assign and column-2 (default-value) on the right side. All the variables have been properly defined in the workflow already, just want to assign in a for-each row. This would let me add easily new variables (declare in workflow and add to xls) and also re-sort easily.
Old style multiple assign (manually adding line by line):
SAP_username = db_parameter.Rows(0).Item(“default-value”).ToString
new idea assign (for each row):
row.item(“variable”) = row.item(“default-value”).ToString
Any idea how I can convince assign that the variable is built out of a variable?