Table Mapping in UiPath

I have a master Data Like this in Which There are Employee Code Employee Name and Some Activities Each employee corresponding to some activity

image

I have a Activity list which has the codes of the activity list like this

image

Now what I want to do is Generate a third Excel File which will read the Employee Code and it’s corresponding activity where yes is mentioned from the first excel then it will go into the second excel sheet corresponding to the activity name which was found in first excel sheet it will pick it’s code and will then write this info into the third excel like this

image

For a better understanding here is an example :
From the above output you can see as in First Excel sheet Employee Code 101 is playing , in the second excel sheet activity code of playing is 1 so the Output generated in the third excel is

image

hope you guys get my problem :slight_smile:

Any help would be appreciated

1 Like

see this

input = test.xlsx (contains sheet1 / sheet2)
test.xlsx (9.3 KB)
result.xlsx (7.2 KB)
uipath workflow
TEST.xaml (16.4 KB)

result.xlsx
image

Was working fine till afternoon

Later this error came from nowhere

its saying employee code doesnt exist in tableName…

did you check your table? what even is tableName

1 Like

Issue is resolved thanks.

1 Like

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