topic Hi Juke.. in Product Forum

Reading Collection by index

NawinAnkathi — Mon, 18 Sep 2017 15:43:00 GMT

Hello team, How can I read a specific value from a collection without using Loops? For example I have a products collection in which it has 100 records, I want to fetch 40th Row Product name (Products[40]), based on the index or the Field name. Please advise asap. Thanks, Naveen

Does ""Filter Collection"" in

Deep.Shah — Mon, 18 Sep 2017 17:07:00 GMT

Does ""Filter Collection"" in ""Collection Manipulation"" Object help in what you are trying to do? Regards, Deep Shah

Utility - Collection

JiriPospisil — Mon, 18 Sep 2017 17:25:00 GMT

Utility - Collection Manipulation Action: Read Collection Field

Thank you Deep and Jiri for

NawinAnkathi — Tue, 19 Sep 2017 09:37:00 GMT

Thank you Deep and Jiri for your responses. Is there any way to directly consume a row from collection using its index or column/field name ? Ex: Products[40] or Products[""Column Name""]

Yes. You can copy rows from

SrinivasaRaoPat — Tue, 19 Sep 2017 09:49:00 GMT

Yes. You can copy rows from collection by using Index of the particular row. use VBO: Collection Manipulation Action: Copy Rows In Copy Rows action you can mention Index of the row and also you can mention how many rows to copy from that index if you want.

Thanks Srinivas for your

NawinAnkathi — Tue, 19 Sep 2017 11:03:00 GMT

Thanks Srinivas for your response. I am just exploring the ways of fetching data from a collection. Apart from Loops or VBO: Collection Manipulation, is there any other way to fetch the collection value using the index similar to the programming languages. CollectionName[0] or CollectionName[""FieldName""]

I think the function you're

Anonymous — Tue, 19 Sep 2017 14:05:00 GMT

I think the function you're looking for is provided in Utility - Collection Manipulation => Read Collection Field where you can provide input parameters as Collection, Field Name and Row Index. The Output is then Value Read which you can store in a variable for further actions. But for some reason, I cannot make it work even in a simple test case. But that's likely because of me, not the object.

If you're looking at this

Anonymous — Tue, 19 Sep 2017 15:57:00 GMT

If you're looking at this functionality, could you help me out, please? I created a sample collection ""cTest"" with a field ""fTest"". Then I typed a few Initial Values for fTest like vTest1, vTest2, vTest3. When I use Utility - Collection Manipulation => Read Collection Field and define the Inputs as Collection = cTest Field Name = fTest Row Index = 2 and Output to Data1(text), I get an execption ""The collection does not contain a field with the name 'vTest1' ??? So, instead of reading / returning the value from the second row (=> vTest2) it's giving an error stating that there's no field named according to the value on the first row (vTest1).

Hi Juke,

NawinAnkathi — Tue, 19 Sep 2017 16:49:00 GMT

Hi Juke, I think you might have given Field Name = cTest.fTest, that is the reason its not able to understand the Field Name.. If this is the case, give Field Name = ""fTest"" (only Field name without Collection as a prefix).. Hope this helps 🙂

Code Stage:

TomBlackburn1 — Tue, 19 Sep 2017 19:51:00 GMT

Code Stage: myOutput = myCollection.Rows.Item(Convert.ToInt32(myRowNumber)-1).Item(Convert.ToInt32(myColumnNumber)-1) Let me know if you need me to explain more.

Hi Juke..

SrinivasaRaoPat — Wed, 20 Sep 2017 10:28:00 GMT

Hi Juke.. Try with Row Index = 0. Because Row Index will starts with ""0"". I hope it will help you.

Thank you for your comments.

Anonymous — Thu, 21 Sep 2017 01:31:00 GMT

Thank you for your comments. I think I found at least a workaround to make it work. And this applies also to writing (Set Collection Field) as well. Expanding my example below, let me specify more fields (ie. columns) like fTest, fTest1, fTest2, fTest3. Now, if I try to read a value from let's say (column) fTest2, row index 1, I get the error message as above, stating that a field named as the value in the first row (=index 0) in fTest2 does not exist. Then the workaround: In Initial values I add a row and type the field names as values like this: (field name) fTest - fTest1 - fTest2 - fTest3 (1st row values) fTest - fTest1 - fTest2 - fTest3 And it works! Just as the error message said. Now the method can find the correct ""field name"". I tried to look at the actual code inside the method, but could not figure out why it's looking for the field name from the first (index=0) row, instead of the real field name above the data rows.