Complex projection in TCC

Summary:

Content (required):

We facing challenge in writing complex projections. We have a requirement of writing complex projections in TCC depending on the values of other projected columns.

For example:

we are required to manipulate the data of Column C based on the data of column A , B and D

If Column A=yes and Column D =“Intern”

then Column C = Intern

else if Column A=yes

then Column C = “ New College Graduate”

If Column A = No

then Column C = “Hourly” OR “Professional” OR “Contractor” OR “Pipeline” OR “Confidential” OR “Intern”

If Column A = blank,

then check if

Column B is in (‘New College Grad (0-2 years)’ OR ‘Silicon Carbide (SiC) and New College Grad (0-2)’)