IFs

Hello

Is it possible to do IFs statement in prep studio with and.

Thanks

------------------------------
Jon Pernice

------------------------------

Find more posts tagged with

English

Monarch

Accepted answers

All comments

Baba_Majekodunmi_703

@Jon Pernice Nice to meet you Jon. Yes it is possible. In the drop down menu, you can create a calculated field using If statements with And, Or, and other conditions.

If you have the most current version it should be in the drop down menu under Column>New Formula Column.

The statement in Monarch is written a little differently than in other software. It would look like this;

IF([Price]> 0 .and. [Item]='CD', 1, 0)

I will try and send some screenshots later or a video if that will help.

------------------------------
Baba Majekodunmi
Solutions Consultant
Altair Engineering Inc.
Manassas VA
978-275-9325
------------------------------
-------------------------------------------
Original Message:
Sent: 06-04-2020 04:05 PM
From: Jon Pernice
Subject: IFs

Hello

Is it possible to do IFs statement in prep studio with and.

Thanks

------------------------------
Jon Pernice

------------------------------"

Baba_Majekodunmi_703

@Jon Pernice Nice to meet you Jon. Yes it is possible. In the drop down menu, you can create a calculated field using If statements with And, Or, and other conditions.

If you have the most current version it should be in the drop down menu under Column>New Formula Column.

The statement in Monarch is written a little differently than in other software. It would look like this;

IF([Price]> 0 .and. [Item]='CD', 1, 0)

I will try and send some screenshots later or a video if that will help.

------------------------------
Baba Majekodunmi
Solutions Consultant
Altair Engineering Inc.
Manassas VA
978-275-9325
------------------------------
-------------------------------------------
Original Message:
Sent: 06-04-2020 04:05 PM
From: Jon Pernice
Subject: IFs

Hello

Is it possible to do IFs statement in prep studio with and.

Thanks

------------------------------
Jon Pernice

------------------------------"

Hi @Jon Pernice, here's a sample screenshot below. Let us know if you need more assistance.

------------------------------
Baba Majekodunmi
Solutions Consultant
Altair Engineering Inc.
Manassas VA
978-275-9325
------------------------------
-------------------------------------------
Original Message:
Sent: 06-05-2020 05:49 AM
From: Baba Majekodunmi
Subject: IFs

@Jon Pernice Nice to meet you Jon. Yes it is possible. In the drop down menu, you can create a calculated field using If statements with And, Or, and other conditions.

If you have the most current version it should be in the drop down menu under Column>New Formula Column.

The statement in Monarch is written a little differently than in other software. It would look like this;

IF([Price]> 0 .and. [Item]='CD', 1, 0)

I will try and send some screenshots later or a video if that will help.

------------------------------
Baba Majekodunmi
Solutions Consultant
Altair Engineering Inc.
Manassas VA
978-275-9325
------------------------------

Original Message:
Sent: 06-04-2020 04:05 PM
From: Jon Pernice
Subject: IFs

Hello

Is it possible to do IFs statement in prep studio with and.

Thanks

------------------------------
Jon Pernice

------------------------------"

Rebecca_Cronin

Hi Jon,

I wanted to also share with you links to Monarch Documentation:

providing more info on Creating Formula Fields: https://docs.datawatch.com/monarch/desktop/Creating_a_Formula_Field.htm?rhsearch=new%20formula&rhsyns=%20

Along with list describing the functions that may be used to create calculated fields in Data Prep Studio : https://docs.datawatch.com/monarch/desktop/Functions_Reference.htm

------------------------------
Rebecca Cronin
Customer Success & Community Manager
Bedford MA
(978) 275-8203
------------------------------
-------------------------------------------
Original Message:
Sent: 06-04-2020 04:05 PM
From: Jon Pernice
Subject: IFs

Hello

Is it possible to do IFs statement in prep studio with and.

Thanks

------------------------------
Jon Pernice

------------------------------"