For Each storing

[ImPratham45 (Prathamesh Patil)]

How to store values that are iterate in the for each ?
for example i retrieved datatable1 columns in item using for each now i want to store that values so how can i store those values and after that how can i see those values in message box?

in DataTable1 there are two columns : number and character

pls also same for row…

[Rammohan91 (Rammohan Banda)]

Check this,

How to use get row item with for each

There are a couple ways. You can use “Get Item” activity and set up its parameters correclty. Most don’t use that method however and instead use “.Item()” with the datarow. So in order to get the datarow you can have this in a ForEach or hardcode the row with the datatable variable. For example, datatableVariable.Rows(0).Item(0).ToString that will return the first column of the first row. You can also replace .Item(0) with .Item(“columnname”) If you have it in a loop, then here is an exam…

Thanks,
Rammohan B.

[ImPratham45 (Prathamesh Patil)]

I get those values but can i store them in a variable?

[Rashmi (Rashmi Pareek)]

You Can follow these steps:

1. Read the excel using Read Range and store the value of excel in DataTable
2. By using For Each Row loop the DataTable
3. Give the box inside the loop and pass the value : row(0).tostring + row(1).tostring and you can store these values in two variable

By using assign activity
value1 = row(0).tostring
value2 = row(1).tostring

and you can give message box with value1 + value2

[ImPratham45 (Prathamesh Patil)]

what if there are 100 of values?

[Rammohan91 (Rammohan Banda)]

Can you explain, what are you trying to achieve by storing them into variables?

Thanks,
Rammohan B.

[ImPratham45 (Prathamesh Patil)]

Actually I am comparing two CSV files then i also want which particular column or row is not matched.I am currently on the following stage of project

new task.xaml (29.0 KB)

[Rammohan91 (Rammohan Banda)]

Check this,

Activities - Compare CSV Files

Comparison of CSV files and storing similar and different records in different csv files

Hi All, My objective is, Compare 2 CSV files. Store similar records in similar.csv Store different records in different.csv I am trying to do following things: Read 2 CSV files. Build 3 blank data tables for storing output and temp usage. DT1, DT2 and DTunion. Do sort and distinct values so that I dont compare same records again and again (Just for code efficiency). [Temporary step] Store both the csv file records in one single datatable DTunion. (kind of union set). Nested for each row an…

Its not feasible to create one variable for each of the value, instead you can have 1 variable for each of the column which will store value of that particular instance of row. Above examples should guide you more on that.

Thanks,
Rammohan B.

[AkshaySandhu (AkshaySingh Sandhu)]

Hello @ImPratham45
if you already have a datatable then use this
(From row In dtDataTable Select colx = row(0).ToString).ToList

above will give you list of all the items from column at index 0, change index as per your need.

let me know if it does not meet your requirement

[ImPratham45 (Prathamesh Patil)]

Here actually they manually give the columns names. In my project columns are varying daily.

[ImPratham45 (Prathamesh Patil)]

ok thank you i will tell yoy after implementation

[srii (srimathi k)]

dt1.column denotes what in your table