BotAM97
(Robot)
November 6, 2020, 8:39pm
1
Hello everyone,
I have a datatable comprising of 7 columns. In the bot, I have 2 different workflows.
One workflow will generate the data for the first 4 columns and the second workflow generates the data for the for the final 3 columns.
How do I have the 2 workflows generate their data on the same row?
User12
(User12)
November 7, 2020, 12:30am
2
Hi @BotAM97
In your first workflow, use add data row activity so that rows along with the values for first 4 columns would get added to datatable.
Psss the datatable as an argument to your second workflow. Use for each row activity to iterate thru each row and set values for ur remaining columns using assign activity.
1 Like
Srini84
(Srinivas)
November 7, 2020, 5:21am
3
@BotAM97
Generate the Rows using First flow 4 columns, so that you have the data in datatable
For second flow use ForEach Row activity to loop into datatable
You have to assign the values like as below
Datatable.Rows(IndexVariable).Item(“ColumnName”).ToString = Your Value
For more reference for the above expression, check below
sorry i can not use this solution…
As I want to Read Next row value before i continue to regiser the current row…
my issue is
When i have done reading current row through if statement … then I want to know… the next row Category before continue…
And if there is no category or no row in table which has Category … then it should continue and register the current row in systerm…
But it giving me error when it there is no row in system–
Hope this helps you
Thanks
1 Like
Hi @BotAM97
Check this workflow
Main.xaml (12.1 KB) 1.xaml (4.4 KB)
2.xaml (4.4 KB)
1 and 2 are invoked in main
I had done a similar kind of scenario relating ur query
Hope it helps you
Regards
Nived N
Happy Automation
1 Like
system
(system)
Closed
November 10, 2020, 6:21am
5
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.