Help

[Navya08]

Hi i need help , i have created workflow which shows results for both the sheets for particular person only: for example : ABC and DEF

Sheet 1: shows the affected business applications and affected applications and affected CI’s

 sheet 2: shows application id , name , its owner etc.

i want to do a vlookup or i want to find the affected business application or affected applications assigned to ABC OR DEF and map affected applications against its id , person wise for example how many affected applications are for the area covered by ABC OR DEF

as shown in reference 1:affected business applications are 

CMS

ESG

ART-u.k

 and reference 2: has the application ids

so in the ouput

CMS should be mapped with application id 

13675

[apathetichell]

you would use a join tool to join a data source with a mapping table.

[Navya08]

But i do not have any common field to join ? Can you help?

[apathetichell]

post some actual data - not jpegs. Where are you hitting an issue? If you don't have a mapping table - build one.