Generate Datatableアクティビティの使い方がよく分からない

こんにちは。
UiPath Studio 2024.10.6Community editionのユーザです。

Generate Datatableアクティビティの使い方がよく分からないので教えてください。

1.やりたいこと

下記のCSVファイルを読み込んでdt_log3を作成したい。

Date,Start,End,TimeSpan,Status
2024/09/21,18:38:54,18:39:12,00:00:18,×
2024/09/21,20:01:43,20:02:33,00:00:50,×
2024/09/21,20:11:21,20:11:35,00:00:14,×
2024/09/21,20:12:22,20:13:28,00:01:06,×
2024/09/21,21:18:11,21:18:16,00:00:05,×
2024/09/21,21:20:57,21:21:12,00:00:15,×
2024/09/21,21:49:53,21:50:10,00:00:17,×
2024/09/21,22:02:19,22:02:40,00:00:21,×
2024/09/22,14:00:28,14:00:56,00:00:28,×
2024/09/22,14:17:04,14:18:49,00:01:45,〇
2024/09/25,17:13:23,17:13:28,00:00:05,×
2024/09/25,17:20:52,17:20:57,00:00:05,×
2024/09/25,17:27:52,17:28:07,00:00:15,×
2024/09/25,17:49:35,17:49:45,00:00:10,×
2024/09/25,17:52:47,17:56:04,00:03:17,×
2024/09/25,17:58:58,17:59:10,00:00:12,×
2024/09/25,18:05:12,18:05:20,00:00:08,×
2024/09/25,18:12:32,18:12:36,00:00:04,×
2024/09/25,18:14:20,18:14:27,00:00:07,×
2024/09/25,18:15:25,18:15:32,00:00:07,×
2024/09/25,19:49:53,19:49:56,00:00:03,×
2024/09/25,19:50:51,19:50:55,00:00:04,×
2024/09/26,19:10:24,19:11:14,00:00:50,〇
2024/09/26,19:36:08,19:36:39,00:00:31,〇
2024/09/26,19:38:11,19:38:45,00:00:34,〇
2024/09/26,19:39:01,19:39:29,00:00:28,×
2024/09/26,19:59:18,19:59:41,00:00:23,×
2024/09/26,20:13:47,20:14:59,00:01:12,〇
2024/09/26,20:28:38,20:31:29,00:02:51,〇
2024/09/26,20:34:16,20:35:51,00:01:35,〇
2024/09/26,21:42:26,21:44:14,00:01:48,〇
2024/09/26,21:46:09,21:47:52,00:01:43,〇
2024/09/26,23:13:12,23:13:54,00:00:42,〇
2024/09/26,23:59:49,23:59:54,00:00:05,×

Generate Datatableのオプション設定を下記の画像のとおりにしても、dt_log3が作成できませんでした。

また、入力の設定はCSVファイルパスではだめでしょうか?

@gorby

Did you click on preview?

How you would use it …use a read text file and read the data and then pass the output as string to this activity

Cheers

Hi Anil_G
Thank you!
I did not know read text file activity is required to put in front of generate datatable activy.
Pls answer me my second question for you!
I found special Japanese Character “〇” was broken in local panel after executing generate datatable activity.

Will you show me how can I see this character as it is?

@gorby ,

Thank you!
After setting “Shift-JIS”, at encode option, I obtained required answer.

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.