Dictionary and Columns Data to Insert in a queue

Help Studio
,
1

Hello,

I’m using dictionary for my project and add the dictionary With two columns in queue folder,
An example for my excel sheet:
Dictionary<string, string>
{ "Name: ", “sam” },
{ "First name: ", “Sandro” },
{ "Title: ", “Mr” },
{ "UserId: ", “123456” }

{“project Id”, “Duration”}
{12345678,3 months }
{87654321,1 months}
{23456789, 2months}
{453617890,1 months}
{12345634,3 months }
{876541000,1 months}
{234561074, 2months}
{453615401,1 months}

I need to Add the data in a queue by each project Id column and duration.
In the details for each transaction in queue folder will be like this:

First transaction:
Name: Sam
First_Name: Sandro
Title: Mr
UserId: 12345
Project_Id: 12345678
Duration: 3 months

Second Transaction:
Name: Sam
First_Name: Sandro
Title: Mr
UserId: 12345
Project_Id: 87654321
Duration: 1 months

My Problem is that I use for each row activity and in the transaction in queue show in the details for all the transaction the same details,

Thanks in advance :blush:

3

Hi @Sloma_Mhehdbi

Welcome to UiPath community

  1. Build a data table with Name, First_Name, Title, UserID, project ID, Duration as columns
  2. Loop through the dictionary and the collection data for project Id
  3. Add data row to the data table

hope this is helpful

4

Hello @Sloma_Mhehdbi If possible, can you please share the sample input excel