IFs
Answers
-
@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
------------------------------"0 -
Hi @Jon Pernice, here's a sample screenshot below. Let us know if you need more assistance.Baba Majekodunmi_21731 said:@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
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
------------------------------"0 -
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
------------------------------"0
Altair Employee