Is there a way to create a DataTable in StudioX?

[umktdm]

Hello,
I am new to StudioX , and I want to create a DataTable.
I could not find a create DataTable in activities?

Could you show me if there is way for me to create a DataTable in StudioX?

Thanks for the help!!

[ashokkarale]

@umktdm,

We have Build Datatable activity for this. Search it in activities panel.

[Yoichi]

Hi,

There are some ways to achieve it.

1. Generate DataaTable from Text
   Set csv text as input and turn on CSV mode and Use first row as Column Header as the following.

2. Build DataTable

First , it’s necessary to turn on Developer option at Filter in Activities panel.
Then we can use this activity and create datatable using wizard as the following.

3. Create excel or csv in advance then use ReadRange or ReadCSV activity.

4. Create datatable variable at DataManager and set New DataTabel as default.

   dt = New DataTable

Then use AddDataColumn and AddDataRow activity etc.

Regards,

[umktdm]

Hi Yochi
Could you please elaborate how can I get to DataManager in StudioX?
I already turned on Developer in Activities but I could not find DataManager in StudioX?

Thanks,
MInh

[Yoichi]

Hi,

Can you try to click DataManager tab as the following image?

Regards,

[umktdm]

Hi Yoichi,

I tried to look for Object Repository in Activities in order to get to data Table but I could not find Object Repository in Activities.

Processing: objectresposiroty.png…

Because I could not find Object Repository, so I think I need to import UI Libraries into my project . I then went to Manage Packages and then tried to look for it under ALL Packages in order to import it. But I could not find UI Libraries under ALL packages.

I may missed some important steps, Could you please show what I may have missed?

Thanks,
Min

[Yoichi]

Hi,

Object Repository is not related to this matter. Can you try to click DataManager tab as the following res arrow point?

Regards,

[umktdm]

Hi YoiChi,
Yes, Thanks! We found it. Data Manager was in the right hand side of StudioX.

[umktdm]

Hi YoiChi,
Sorry for asking a very trivial question regarding on how to create a simple data table using Data manager in StudioX. I tried to search on Web on How to create data table using StudioX but I came across many articles or helps on how to create data table in Studio but StudioX was different than Studio. So I tried to take a shoot of creating data table in studioX , and as a result, I came into many errors.

First, I’d like to create a sample Employee tables having two columns name, and hour_worked. Name is a String, and hours_works is decimal.

Processing: Screenshot 2024-11-29 103921-pic1.png…

I went on create two variables name, and hour_worked on Data Manager

I then created a DataTable which hold those two colums name, hours_worked , and the two rows contained the values of the two columns but I got an error saying that my columns name, and hours_worked were not defined. I may miss some important steps but I could not figure it. So if you can help me to show me what I have missed then I would be greatly appreciated!!

Next , If we get the Data Table piece figure it out, and it is working; then how could add the data table into my current workflow? I tried to search for something like “Add data Table” in activities in StudioX but I could not locate any.

Many Thanks for the help!
Min

[Yoichi]

Hi,

If you are unfamiliar with datatable, it may be better to use BuildDataTable, as the following sample.

Sample
NewBlankTask20241130-1.zip (50.2 KB)

Regards,

[umktdm]

Hi YoiChi,
Thanks for the sample example.
Could I ask how do you build the data table ? Do you create a BuilddataTable from Data Manager , or do you use BuildDatatable from activities?
Best Regards,
Min

[umktdm]

Hi YoiChi,
Thanks for giving me the Great example! I figure it out that we got the Build Data Table from activities.

We are now having the DataTable from one task namely task1. If I have another task namely task2, and I am interested on passing the datatable from task1 to task2.

May I ask you on how we are going to pass the data table from task1 to task2 ? Could I use argument in DataManager in task1 to pass the DataTable from task1 to task2?

Thanks so much for the help,
Min

[Yoichi]

Hi,

@umktdm

May I ask you on how we are going to pass the data table from task1 to task2 ? Could I use argument in DataManager in task1 to pass the DataTable from task1 to task2?

As you use StudioX, it may be better to use xlsx or csv file instead of passing it as argument, I think.

1. Save datatable as xlsx or csv using WriteRange, WriteCSV etc. in Task1.
2. Read it using ReadRange or ReadCSV in Task2.

Regards,