Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Change Data using Indb tools

rats
6 - Meteoroid

Hey Guys,

 

I have to conditionally change my data using indb tools.

 

I have data like

 

cust Quantity   Q1   Q2

1          1            2     3 

2           5           4     6

3           4           4     6

 

 

CASE WHEN "QUANTITY" <Q1 THEN "HEAD"=Q1

ELSE "HEAD"=Q2

 

*Head is a new column that I want to create

 

I have tried using the above case statement using indb formula but it doesn't work.I am ok to use any other in db tool as well.

1 REPLY 1
Inactive User
Not applicable

Formula tool for HEAD

 

IF "QUANTITY"<"Q1" THEN "Q1" ELSE "Q2" ENDIF

Labels
Top Solution Authors