Data360 Analyze

Welcome to the Data360 Analyze community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Product Documentation  Ideas Portal

Discussions

Members

Resources

Events

 View Only

  • 1.  Formatting a column based on another columns cell text

    Employee
    Posted 02-02-2017 04:36

    I am reading data from an Excel file. One field contains a string in each row, if a certain substring(s) is present I want to populate another predefined but empty field with a 'Y' or 'N' otherwise. How can this be done? Below, if column A contains a 't' and no 'r' I want to output 'Y'.

        A        B
      cat       Y  
      dog      N
      rat        N



  • 2.  RE: Formatting a column based on another columns cell text

    Employee
    Posted 02-02-2017 07:18

    In a transform node:

    b="N"
    if A.strFind("t") and not A.strFind("r") then b="Y"
    emit A
    emit B=b