You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Complex projection in TCC

Received Response
1
Views
1
Comments

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)’)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!