Table Mapping in UiPath

[Ishan_Shelke1 (Ishan Shelke)]

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

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

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

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

hope you guys get my problem

Any help would be appreciated

[jack.chan]

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

[Ishan_Shelke1 (Ishan Shelke)]

Was working fine till afternoon

Later this error came from nowhere

[jack.chan]

its saying employee code doesnt exist in tableName…

did you check your table? what even is tableName

[Ishan_Shelke1 (Ishan Shelke)]

Issue is resolved thanks.