Googleスプレッドシートにて以下の各セルから値を抜きだし、それぞれの変数に格納したいと考えております。
範囲の読み込みを行い、Datatable型として変数に格納し、繰り返し（データテーブルの各行）でそれぞれの変数に格納したいと考えているのですが、
Bodyの中に代入アクティビティを入れてCurrentrowで取得しようと考えており、確認をした所、変数が取得できているのかイマイチ分かりません。
代入アクティビティの保存する値には何と指定すれば適切に取得できるかどなたかご教授頂ければと思います。
画像をアップロードし忘れました。
How can I store each output value in a variable?
Hi @ml.system
Take an Assign activity and you can use below syntax
Save to : OutputVariable
Value to Save: CurrentRow("ID").ToString
Hope it helps!!
With that expression, the values are written sequentially to a single variable, right? I want to store them in multiple variables.
Do you want to store each value in a separate variable @ml.system
Regards
Exactly.
thanksfull for teach
Hi @ml.system
When you run For Each row in DataTable for the datatable read it will only the single value after that what is the process you want to do??
Regards
I want to store the values in multiple variables and input them into a browser. Are there any other good activities for this?
Hi @ml.system
Inside For Each Row in DataTable use Use Application/Browser and indicate the browser screen.
Give Type Into where you want to type the ID and pass CurrentRow("ID").ToString in Type Into and comple the next process you want to do.
This will take each ID from every row and enter into browser.
Regards
After entering one variable, you need to perform a task. Once that task is completed, you’ll input the next variable and proceed with the next task.
Does each ID has different task @ml.system
Regards
No, they are similar tasks.
You don’t require separate variable for each id. Put your logic to process task inside the for each loop and use CurrentRow("ID").ToString as variable to proceed further.
Thanks,
Ashok 
Got it. Thank you very much.
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.