Skip to Content
0
Jun 08, 2018 at 03:04 AM

Apply if else statement to map columns

82 Views

Hi, I have searched the forum and could not really find exactly what I wanted (maybe the keyword I used was not appropriate).

This is the case, I have a source table(image 1) image1.png. There is a column of a datetime(TIMESHEET_DATE) format and one for a days due(DaysDue).

I would like to apply if else statement during transformation and mapping(image2) image2.png which can map the datetime column applying if else statement(or so called decode?) to the target table(image3) image3.png which have 3 columns( one for name, one column for daysdue >=3, and last for daysdue <3).

How do I exactly apply conditional statement for allowing the datetime column in source table to map to two different separate column storing the datetime in target table based on the condition i would like to apply?

Sorry for my inappropriate grammar usage they may not have a very transparent clarity on the question I asked. I hope the community understands what I would like to achieve.

Attachments

image1.png (33.9 kB)
image1.png (33.9 kB)
image2.png (34.6 kB)
image3.png (19.3 kB)