Hello team, i need to add data to datable using add data column and put data in Database. pls provide the solution.Tq

[Lokesh_M2 (Lokesh M)]

This is my scenario.
1.I am iterating data(Name) using ForEach Activity.
2.Now i need to add data(Name) to DataTable to specific column.
3. Same scenario for remaining data also(Mobile, category, ID etc)
4. Once all column data added to Datatable I need to put in DataBase and clear the DataTable.

Pls provide the solution.Tq very much

[Harshith_Adyanthaya]

Hi @Lokesh_M2,

Can you tell us what is your input? From where are you getting Name, Mobile and other data?

[Lokesh_M2 (Lokesh M)]

Hi, iam getting data from matches activity and iterating using For each

[Harshith_Adyanthaya]

Okay. Then you can use add datarow activity in same loop to add to datatable.

Add your data in place of name, mobile etc.

Later use Bulk insert activity to upload the datatable into database.

[Lokesh_M2 (Lokesh M)]

But my scenario is iam iterating each data using individual Foreach

[LAKSHMI_NARAYANA_PEMMASAN (LAKSHMI NARAYANA)]

Please post some sample raw data so as to get exact scenario

are you setting row data in each iteration or single column data (if so the reason for setting a single column data )

Regards

[Harshith_Adyanthaya]

Okay. If it is possible try to do in one for each, it would be more efficient.

Based on your current scenario, Use Build data table activity with all required columns.
Inside the first for each i.e Name, use add datarow to add only Name data.
Inside other for each, use assign activity.

outputDt(“Mobile”)(i) = mobileNo

where i is index of the for each.

Hope this helps.

[Lokesh_M2 (Lokesh M)]

Hi, iam setting In each iteration single column data

[Lokesh_M2 (Lokesh M)]

This my sample scenario

[LAKSHMI_NARAYANA_PEMMASAN (LAKSHMI NARAYANA)]

can you please refer to the below post you can get better understanding

https://forum.uipath.com/t/hi-team-pls-provide-regular-expression-for-the-data-tq/531373/8

Regards

[Anil_G (Anil Gorthi)]

@Lokesh_M2

On change that you can do is…use 4 matches activity at first…and store them
To 4 variables…and I hope all will return same number of values…

So you can use one for loop on one of the matchcollection variables…and for loop properties has a property called index…to which we can add a variable and use it to iterate through remaining match collections

So in add datarow you can use like this

Eg: {currentitem.Value,match2(indexvalue).value, match3(indexvalue).value, match4(indexvalue).value}

Then in one loop you call add all at a time

Here each match is the output of each matches activity

Hope this helps

Cheers

[Harshith_Adyanthaya]

Try this sample workflow.

Provided all data counts are same.

[Lokesh_M2 (Lokesh M)]

Hi @Harshith_Adyanthaya, what is the type argument for ForEach used?
it is showing error if i am using using system.text.regularxpression.match

[Harshith_Adyanthaya]

System.Text.RegularExpressions.Match

What is the error?

[Lokesh_M2 (Lokesh M)]

[Anil_G (Anil Gorthi)]

@Lokesh_M2

Strhotelname looks like a string variable and not matches variable …can you scheck the same please

Basically as explained above the concept is to loop theough each matched item for different matches

@Anil_G

So you can use one for loop on one of the matchcollection variables…and for loop properties has a property called index…to which we can add a variable and use it to iterate through remaining match collections

So in add datarow you can use like this

Eg: {currentitem.Value,match2(indexvalue).value, match3(indexvalue).value, match4(indexvalue).value}

Hope this helps

Cheers

[Lokesh_M2 (Lokesh M)]

yes now i used matches variable.Now while running error thrown like this

[Anil_G (Anil Gorthi)]

@Lokesh_M2

Can you show how you are using…looks like its different again

Alternately try this match1.ToArray) (0).Value

Cheers

[Lokesh_M2 (Lokesh M)]

[Anil_G (Anil Gorthi)]

@Lokesh_M2

I see you are using strnachotel…can you check the variable type please

Cheers