Could someone explain this to me please? Variable to Iterate - Unrecognised options

[StewD]

Hi,

 

I am getting this error when trying to select the "Variable to Iterate" in the "Loop Iterator" component.

 

The variable v_pageOffset is a numeric, job variable and has a value of 1.

 

I have also tried entering no value in the job variable but then end up with the error “Input required”.

 

In the component I am adding the variable name by clicking “…”, check marking “Use variable” and then selecting the variable from the drop-down list.

 

 

Appreciate any advice on what I’m doing wrong. Thanks in advance.

[kartik.parate]

hey Stew D just remove $ and { } from variable to iterate. it will work. just write variable name for ex:- v_pageOffset

[StewD]

Thanks Kartik, that worked.

 

So the question (for Matillion) is why?

 

I mean, what's the point of ticking "Use variable" and then selecting it from a drop-down if you have to manually enter it anyway?

[StewD]

Thanks Michael.

 

OK, so it works the exact opposite of what I thought. To me a checkbox labelled "Use Variable" should be selected if I want to use a variable.

 

Exactly as you described, without the checkbox my variable shows up in the drop-down list.

 

Seems backward to me, but maybe it's just upside down because I'm an Aussie?! 😆

 

Appreciate everyone's input ... I can guarantee I won't get caught out on that one again!

[MichaelBoucht]

Hello,

 

the field is 'Variable to iterate', meaning, it's asking for a variable. Without the checkbox, you get a list of variables that are available NUMERIC variables available.

 

The checkbox is used for generic purposes, you can have the NAME of the NUMERIC VARIABLE in a TEXT VARIABLE determined somewhere before this loop.

 

Hope that helps clarifying :)

 

Br,

Michael