Logical and/or/not operators

  • Posts: 3
  • Thank you received: 0

Logical and/or/not operators was created by jacksparrow777

Hi Team,

I am trying to apply conditions based on multiple fields. Something like below. Is this possible through transformation
if (field1 == i and field2 == h) then
Please let me know how to combine such operations
2 weeks 7 hours ago #21322

Please Log in or Create an account to join the conversation.

  • Posts: 8283
  • Karma: 33
  • Thank you received: 540

Replied by admin on topic Logical and/or/not operators

Can you provide more context, please?
If you trying to do it inside the transformation this one thing
if creating a package is another thing
Mike
ETL Architect
2 weeks 5 hours ago #21323

Please Log in or Create an account to join the conversation.

  • Posts: 3
  • Thank you received: 0

Replied by jacksparrow777 on topic Logical and/or/not operators

Yes, I am trying to do it inside transformation.
I have two columns as input and have to populate a third column based on combination of input columns.
Please find the attached screenshot of my sample task. Based on combination of Category and Amount I need to populate column Output.
Could you please let me know if this possible inside transformation.
2 weeks 5 hours ago #21324
Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 8283
  • Karma: 33
  • Thank you received: 540

Replied by admin on topic Logical and/or/not operators

Thank you for the clarification.
You can combine two fields together and then use compare values transformation
www.etl-tools.com/wiki/aetle/transformat...neous/compare_values

we can create a working example for you if you wish
Mike
ETL Architect
2 weeks 3 hours ago #21325

Please Log in or Create an account to join the conversation.

  • Posts: 8283
  • Karma: 33
  • Thank you received: 540

Replied by admin on topic Logical and/or/not operators

Please have a look a the following example
www.etl-tools.com/automation/0019-compare-two-values.html
I hope you will find it usefull
Mike
ETL Architect
1 week 2 days ago #21326

Please Log in or Create an account to join the conversation.

  • Posts: 3
  • Thank you received: 0

Replied by jacksparrow777 on topic Logical and/or/not operators

Hi Team, Thank you for the suggestions. I used calculation transform to acheive this
1 week 16 hours ago #21327

Please Log in or Create an account to join the conversation.

 

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies