All,

I'm having some trouble calling a specific row from a dataset utilizing a variable.

I believe that the syntax to do this is...
%DatasetName(2).ColumnName%
Per the help guide under Reference>AML>Datasets

However, this example shows only how to do so with an integer or fixed value. I want to do this dynamically, with a counter.

My dataset is named "Current_Voyages". I am attempting to do the following:
%Current_Voyages(%i%).SHIP_NAME%
Where i is a counter. However, I am encountering errors when attempting to run this or other similar variations with a variable specifying the row number to use. Is there a way to accomplish what I want?

I will eventually have to build a second counter, j, for this task as well. For example, I might need to access entry i (with i=10) for one column and then access entry j (with j=2, 5, 7, etc.) for another column.

I'm considering using an array to perform this work, but I wanted to see if a simpler solution existed before exploring that. I have included my aml as well.

Best,

Jake

Hi Jake,
The extra % is not needed inside the expression, please remove it. See below:


Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder)
<AMVARIABLE NAME="myIndex" VALUE="1" /> <AMENVVARS ACTIVITY="list" RESULTDATASET="theList" TYPE="user" /> <AMSHOWDIALOG>%theList(myIndex).VarName%</AMSHOWDIALOG>

-------------------------
Thank you for choosing AutoMate

Hamid Noorbakhsh | Senior Software Engineer
AutoMate | A Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700