How to store Value in to data table

[uday_kumar (Udaya Kumar)]

Hi Team,
I have some data in assets like 20;30;40;50;60; and i need to split that data and store this data into build data table column
what i need to do?

[syedabidraza (syed)]

Go through the link , detail explanation is given !!!

Build Data Table

[Christopher_Gomez (Christopher Gómez)]

I think the activity Generate Data Table is more suitable for your dilema.
Generate Data Table
Here the link to the activity explanation on how to use it.

[Fer]

You also can use the string split option, and then store into excel file.

[Suman7 (Suman)]

@uday_kumar

1. Build datatable
2. Spilt method and access it individually using their index
3. Add data Row activity

[uday_kumar (Udaya Kumar)]

Hi,
But here we don’t use excel bro.

[Lahiru.Fernando]

Hi @uday_kumar

There are few things that can be done…

The best suitable one for you is the Build Data Table activity. It will help you design and build the datatable in the workflow itself.

Next, use the string values you got from the asset/ assets and split them by the ‘;’ or any other value which can be used to do so…

@uday_kumar

20;30;40;50;60;

To split, you can use the below code in an assign activity
VariableName.Split(";")

Now, since you have the values separated, you can add them to the datatable you created easily by using the Invoke Method activity which is similar to below…

Hope it helps!!

Thanks
Lahiru