Identify Extracted Data Based On Excel File

Help Studio
, , , , , , , , , ,
1

Hii Team,

The image is a table listing job titles categorized under Human Resources, Marketing, Research and Development, and Administration. (Captioned by AI)
The image is a table listing job titles categorized under Human Resources, Marketing, Research and Development, and Administration. (Captioned by AI)1410×295 31.3 KB

We have an Excel Column with 4 Category Defined

Category1:Human Resources (HR) and UID = HRID

Category2:Marketing and UID = MID

Category3:Research and Development and UID = RDID

Category4:Administration and UID = ADMINID

We are Extracting Data From Portal

Example

DataExtracted=Marketing Manager
HR Generalist

Then print Log It belongs to Category 1 and Category 2 and UID would be HRID,MID after analyzing data in column

Similarly based on Data Extracted it needs to Identify the Category for whichever data Extracted for others in same way

Have attached the Excel for Reference
JobRole_UID_Category.xlsx (5.2 KB)

Thanks in Advance

2

image
image1052×2232 133 KB

image

image

Full listing would be like this:
image

3

Thanks @sudster

Could you share a reference xaml if possible

4

@NISHITHA , would you like the whole output or single output (Category, UID) for a specific input (Role)?

5

For any 1 scenario

Where there are two category defined would be fine

So can go through the structure followed

6

Here you go:

IdentifyExtractedDataFromExcelData.xaml (17.9 KB)

Studio version 2023.10.6

7

Thanks @sudster will definitely check it