How to create a variable list from a table field

[#1]

Hi,

I'm trying to build a match-clause for a load script.

The current values are stored in a table called LatestProfileAssessments, field name is Assessment_Period_Sort.

How can i fill a variable vLatestPeriods to look like '201402','201401','201312','201311'

?

Thanks.

[#2]

- The table Sort_Tmp contains 180 rows.

- Done - not working, as the variable is still  not created

- The field in the DB is of type String. That's why I try to convert to date during load - maybe there is an error?

[#3]

Use Set instead of Let ..

[#4]

OK. Data is retrieved from SQL database. But the dark hole comes after.

Peek syntax is: peek('field name with quote', number, 'table with quoute')

I think you forgot one quote in the first argument.

Mayi ask yoy to check ?

Fabrice

[#5]

This won't work as it then doesn't calculate the right side, but instead writes the string as variable.

[#6]

That's it, now it works :-).

Thanks for your support and patience :-).