Creating a new column using either custom or conditional column value

Question

Hi,&nbsp;I have an existing import table containing of date values as such:ProcessStep NameLast UpdateStep aStep bStep cStep dP1Step a01-01-0101-01-01&nbsp;&nbsp;&nbsp;P2Step b07-07-0103-03-0107-07-01&nbsp;&nbsp;P3Step a02-02-0102-02-01&nbsp;&nbsp;&nbsp;P4Step d06-06-0104-04-01&nbsp;&nbsp;06-06-01P5Step c05-05-0103-03-01&nbsp;05-05-01&nbsp;&nbsp;How can I create a new column to replace the Last Update column in the Query Studio to meet the following condition:When Step Name = Step b, Last Update will be replace with Step a valueWhen Step Name = Step d, Last Update will be replace with Step a valueElse = Last Update valueFinal table should looks like this: (Highlighted value is the updated value)ProcessStep NameLast UpdateStep aStep bStep cStep dLast Update1P1Step a01-01-0101-01-01&nbsp;&nbsp;&nbsp;01-01-01P2Step b07-07-0103-03-0107-07-01&nbsp;&nbsp;03-03-01P3Step a02-02-0102-02-01&nbsp;&nbsp;&nbsp;02-02-01P4Step d06-06-0104-04-01&nbsp;&nbsp;06-06-0104-04-01P5Step c05-05-0103-03-01&nbsp;05-05-01&nbsp;05-05-01&nbsp;Thanks.

anonymous · Accepted Answer

Hi&nbsp;Roy_tap&nbsp;&nbsp;add a custom column&nbsp;if [Step Name]="Step b" or [Step Name]="Step d" then [Step a] else [Last Update]&nbsp;

Forum Discussion

Creating a new column using either custom or conditional column value

2 Replies

Related content

Create conditional index column

Create measure to return value from column when condition met for two other columns

Create columns group

Conditional Column with Multiple Conditions

Create Conditional Column Based Upon Two Other Columns

Process	Step Name	Last Update	Step a	Step b	Step c	Step d
P1	Step a	01-01-01	01-01-01
P2	Step b	07-07-01	03-03-01	07-07-01
P3	Step a	02-02-01	02-02-01
P4	Step d	06-06-01	04-04-01			06-06-01
P5	Step c	05-05-01	03-03-01		05-05-01