How to use If Else in Wrangler Directives ?

[yogesh walia]

Hi,

How we can use if else conditions in wrangler recipe ?

Thanks

[Sreevatsan Raman]

Yogesh, 

What's your use-case? 

If you'd like to set a column to a specific value based on condition, then the set columns directive allows you to specify a JEXL expression. As an example, if you'd like to add an  is_text column and set it to true based on call_type you can use a directive like the one below

set-column :is_text exp:{call_type == "SMS" ? true : false}

Let us know if this helps, or if you have any further questions, would be good to understand what you are trying to accomplish.

Thanks,
Sree

--
You received this message because you are subscribed to the Google Groups "CDAP User" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cdap-user+...@googlegroups.com.
To post to this group, send email to cdap...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/cdap-user/CAPu8orSw0XsmeUHLqXMPQJWwoK7YZb2bxkLK2BQhXVO-OhXL-g%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[yogesh walia]

I need to call different recipes using if-else 

To view this discussion on the web visit https://groups.google.com/d/msgid/cdap-user/CAA%3DcB-jDsUAHv77_ySOT4%3D3QGtvuTwj42%3DevipbKnVkrFmxpuA%40mail.gmail.com.

[Nitin Motgi]

right now only grammar support is implemented. We have plans to add full support for execution of simple and nested if ... else ... 

As of now it’s not fully supported.

Nitin 

To view this discussion on the web visit https://groups.google.com/d/msgid/cdap-user/CAPu8orQ71bahT0tx%2BoHZW5PmvCgNpX7f2%2BCSFJfKOb%2BSFrsFrA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

--

Nitin Motgi

"We reap what we sow. We are the makers of
our own fate. The wind is blowing; those
vessels whose sails are unfurled catch it, and
go forward on their way, but those which have
their sails furled do not catch the wind. Is that
the fault of the wind?....... We make our own
destiny.”
                -- Swami Vivekananda

[Luiz Rodrigo Tozzi]

Hi Sree

I'm using CDAP 6.5.1 and 6.6.0 in GCP (Data Fusion) but everytime I try to use your set-column i get this error:

set-column :uc_origem exp:{project_name == “FOUNDATION” ? “2122” : “None”}

Error occurred : io.cdap.wrangler.parser.DirectivesLexer cannot be cast to org.antlr.v4.runtime.Parser

All columns are string and I'm using Wrangler 4.6.0

Any ideas?

Thanks

[Sreevatsan Raman]

Can you make sure they are not null by adding a check before this directive?

To view this discussion on the web visit https://groups.google.com/d/msgid/cdap-user/fc62d7b9-5b55-4e34-b839-1cce294262ban%40googlegroups.com.

[Sreevatsan Raman]

Looks like a problem with quotes

set-column :uc_origem exp:{uc_origem == "FOUNDATION" ? "2122" : "None"}

I tried the above command and it works. 

On Wed, Mar 23, 2022 at 6:07 AM Luiz Rodrigo Tozzi <to...@ipnet.cloud> wrote:

Yes.

uc_origem is a new column but it gives the same error if I use an existing string not null column.

project_name is not null and also string

To view this discussion on the web visit https://groups.google.com/d/msgid/cdap-user/b0f8736f-8af0-4aa0-bb38-fc3bf412eeb7n%40googlegroups.com.