Variable Concatenation

[TelmoERF96]

Hello everyone,

I am running an extraction that stores independent values in variables name 'LinkCMVMConsulta0', 'LinkCMVMConsulta1', and so on up to 'LinkCMVMConsulta4'.

That extraction is working as intended the problem is that I want to access each one inside a For each action and I already have a variable named 'Counter' starting at '0' and incrementing with each iteration of the loop.

Since all my variables start with 'LinkCMVMConsulta' and then have a number in front of them changing I was thinking of appending the 'Counter' to the text 'LinkCMVMConsulta' and use it as a variable, not as a string, and I have not been able to do so.

I tried writing %LinkCMVMConsulta%%Counter% inside the Set variable action but it gives me an error saying that %LinkCMVMConsulta% doesn't exist which is true, so I don't know what to do .

If anyone knows any way to help I would really appreciate it.

Thanks in advance,

Telmo Ferreira

[UshaJyothi20]

if you need to concatenate then try this 

%LinkCMVMConsulta+Counter%

Hope this helps

Usha

[TelmoERF96]

Thank you for your response @UshaJyothi20 

But that still doesn't work, I still get the error 'variable "LinkCMVMConsulta" doesn't exist.

[UshaJyothi20]

can you please share some screenshots?

and which type of data is there in the variables

[TelmoERF96]

Sure @UshaJyothi20 

The 'LinkCMVMConsulta' variables have URLs stored as text value

And the 'Counter' variable that has a numerical value

When I tried what you proposed the action gave me error without even running the code saying variable 'LinkCMVMConsulta' doesn't exist, which in fact doesn't.

[UshaJyothi20]

youe variables are named as LinkCMVMConsulta0

and LinkCMVMConsulta1

so you need to use the same variable from the select or give the same name

like

%LinkCMVMConsulta0+Counter%

%LinkCMVMConsulta1+Counter%

Hope this helps

Usha

[TelmoERF96]

@UshaJyothi20 

I know that is the correct way the variable should be written, that is why I wanted to write it like this LinkCMVMConsulta + Counter. So it would automatically change the variable to the correct one for each iteration of the loop I'm running. Without a way to write the variable dynamically I guess I will have to use a bunch of If and Else to get the correct output I want

[UshaJyothi20 · Accepted solution]

Do one thing you can crate list of that variables or you can write them in an excel and you can loop through them

then you can write 

%currentitem+counter%

Hope this helps

[TelmoERF96]

Thank you for your time @UshaJyothi20 that works.

Was thinking I could achieve the same result with less actions but it's the result I wanted so thank you once again for all the help.