7 Replies Latest reply: Aug 2, 2012 5:00 AM by Jason Michaelides

# If Exists

I have a scenario in which i need to check value from the table exists in the excel file and assign a flag.

I have a table of employee containing employeeid and department, there is another table containing employee education info (employeeid and degree).

Now i have an excel list containing department and degree as two separate columns.

I need to check if the department of employee AND degree of the employee EXISTS in the list , put a flag(1) on it else 0 in employee table.

• ###### Re: If Exists

I don't quite follow what you're asking. Can you provide an example?

• ###### Re: If Exists

Table 1:Employee

EmpId     Name     Department

1               Abc          IT

2               XYZ          IT

3               PQR          Finance

Table 2: Employee_Education

EmpId     Degree

1               MS(IT)

2               BS(IT)

3               BCom

Excel List:

Department     Degree

IT                         MS(IT)

IT                         BS(IT)

REQUIRED TABLE

EmpId     Name     Department     Flag

1               Abc         It                    True

2               XYZ          IT                 True

3               PQR        Finance         False

• ###### Re: If Exists

Thanks for the example. Try this:

Map_DeptDeg:

Department & '/' & Degree

True

FROM Excel...;

Employees:

EmpID

,Name

,Department

FROM Table1...;

LEFT JOIN (Employees)

EmpID

,Degree

FROM Table2...;

Final:

*

,ApplyMap('Map_DeptDeg',Department & '/' & Degree,'False') AS Flag

RESIDENT Employees;

DROP TABLE Employees;

Hope this helps,

Jason

• ###### Re: If Exists

The solution is not working for me, it is giving all False except 2 employees which dont have any department.

• ###### Re: If Exists

There's a typo in my Mapping script:

Map_DeptDeg:

Department &amp; '/' &amp; Degree

,True

FROM Excel...;

If this still doesn't work please post some sample data or better still your app and I'll take a look.

Jason

• ###### Re: If Exists

Thanks Jason

I have used the code already removed the typo, but the problem is still there, to make it more clear in my excel list ; department column contain 5 entries whereas the degree contains around ten entries,

do u think it might creating the error??

• ###### Re: If Exists

Can you provide some sample data?