![]() |
![]() |
We are currently migrating this forum over to our HelpSystems domain. Please post all new threads in our new HelpSystems Community Portal. |
![]() |
|
![]() |
AutoMate Discussion | ![]() |
help :
faq :
home
|
||
Latest News:
|
latest topics : statistics |
Topic Title: Call dataset value from specific row using a variable Topic Summary: Created On: 06/14/2018 08:41 AM Status: Read Only |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|||
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) ------------------------- Thank you for choosing AutoMate Hamid Noorbakhsh | Senior Software Engineer AutoMate | A Division of HelpSystems HelpSystems, LLC | T: +1.213.738.1700 |
|||
|
FuseTalk Enterprise Edition v4.0 - © 1999-2021 FuseTalk Inc. All rights reserved.