topic Re: Specifying a table for the value of a variable in App Development

Specifying a table for the value of a variable

bajor14 — Fri, 15 Nov 2024 21:59:33 GMT

Hi All!

How can I enter the years in the Yearlist table into the vLoadedPartitionList variable?

LET vStartingYear = Year(Today()) - 4; LET vTargetYear = Year(Today()); [YearList]: LOAD $(vStartingYear) + RowNo() - 1 AS Year AUTOGENERATE $(vTargetYear) - $(vStartingYear) + 1; LET vLoadedPartitionList = ???; // Partition List. If it is not null, then only this partition(s) will be loaded. (for yearly partition(s): YYYY (eg: '2019, 2020')

Thanks for all the help!

Re: Specifying a table for the value of a variable

AgatheClero — Thu, 16 Mar 2023 14:45:33 GMT

Hi @bajor14 ,

Not sure to understand your question, but if you want to store the years which is in your table YearList into your variable vLoadedPartitionList, you can do this :

LET vStartingYear = Year(Today()) - 4; LET vTargetYear = Year(Today()); [YearList]: LOAD $(vStartingYear) + RowNo() - 1 AS Year AUTOGENERATE $(vTargetYear) - $(vStartingYear) + 1; LET vCountYear = FieldValueCount('Year'); Trace Number of years : $(vCountYear); SET vYear_init = 1; For i=1 to $(vCountYear) If '$(vYear_init)' = 1 then LET vYear_init = FieldValue('Year',$(i)); Else LET vYear_init = '$(vYear_init)' & ',' & FieldValue('Year',$(i)); End If Next LET vLoadedPartitionList = chr(39) & '$(vYear_init)' & chr(39); Trace vLoadedPartitionList = $(vLoadedPartitionList);

Hope this helps.

Regards,

Agathe.

Re: Specifying a table for the value of a variable

bajor14 — Fri, 17 Mar 2023 07:31:52 GMT

Hi @Agathe!

Perfect! That's exactly how I wanted it! Thank you very much!!!!!