How to identify unique values from an excel column and write the data to a different excel in one row

Help Activities
,
1

Hello Everyone,

How can I achieve the below?

Conditions

  • IF Column J (Is Primary job) = “Y” Then Column P (Manager ID) = Primary Manager

  • Scenario A - IF an Employee’s Primary Manager is equal to Manager 2, 3, 4 etc. These records should not populate in the upload file

  • Secaniro B - IF an Employees record has Y in the IS primary Job Column that record should not populate in the upload file, The record should populate if the IS primary Job Is N and the ID’s are not equal to the Managers ID

  • Scenario C - Only the Unique record should populate

  • Scenario D - IF the ID’s are not equal to the manager ID, the records should populate in one row as Manager 2, Manger 3, Manager 4, etc…

Input file

image
image1527×335 202 KB

Expected output

image
image885×97 2.59 KB

2

Hi @Robot2_Automation
Check this script:

Identify_Unique_Values.zip (16.8 KB)

Happy Learning.

3

Hi @Ali_Murtaza,

I’m seeing the below error in the workflow.
image

4

Hi @Ali_Murtaza - I want the output to be in the below format, but when i try to change it I’m getting multiple errors. can you please assist?

image
image885×97 2.59 KB

5

You have packages issue.
Add Package UiPath.System.Activities

6

Can you please share the screenshot of the error or activity you are getting the error on?
Also you might need to change the column names in all places.
For reference you can check the files I have shared with you. Cross check the column names and update them in the Automation.

image
image602×599 20.9 KB

7

For example in your case you will have to change the highlighted values to:

  1. Output_Table(Output_Table.RowCount-1)(“Employee ID”)
  2. Output_Table(Output_Table.RowCount-1)("Manager "+(Count_1+1).ToString)

Also if you want to start from Manager 2 you will have to write:
Output_Table(Output_Table.RowCount-1)("Manager "+(Count_1+2).ToString)

8

@Ali_Murtaza This is the error I get.

image
image1268×312 20.8 KB

9

you need to add a space after Manager.

Use this:
Output_Table(Output_Table.RowCount-1)("Manager "+(Count_1+2).ToString)

10

@Ali_Murtaza Thank you for assistance. :+1:

1 Like
12

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