Network Automation Software
You are not currently logged on. You must be logged on in order to post. Log on
Or Create a new account
AutoMate Discussion
Decrease font size
Increase font size
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
Search Topic Search Topic
Topic Tools Topic Tools
View similar topics View similar topics
View topic in raw text format. Print this topic.
 06/14/2018 08:41 AM
User is offline View Users Profile Print this message

Author Icon
JakeBennett
n00b (>6 posts)

Posts: 1
Joined: 04/12/2018

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


 06/14/2018 03:47 PM
User is offline View Users Profile Print this message

Author Icon
Hamid Noorbakhsh
HelpSystems

Posts: 454
Joined: 07/29/2008

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
Statistics
18257 users are registered to the AutoMate Discussion forum.
There are currently 0 users logged in.
The most users ever online was 6686 on 11/01/2020 at 01:24 AM.
There are currently 1010 guests browsing this forum, which makes a total of 1010 users using this forum.

FuseTalk Enterprise Edition v4.0 - © 1999-2021 FuseTalk Inc. All rights reserved.

Sitemap Network Automation Software Blog