LAE

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

Discussions

Members

Resources

Events

 View Only
  • 1.  Convert Long to String

    Employee
    Posted 05-08-2015 05:29

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: jchartrand

    Just starting out with Lavastorm... (2nd day!)

    I am trying to enrich my data set using the lookup node.

    I believe that it is failing as one set is string and the other is long. How can I convert a column of data from Long to String?


  • 2.  RE: Convert Long to String

    Employee
    Posted 05-08-2015 05:32

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: ryeh

    Hi, Josh! Welcome to the forum! There are two ways:

    1. Use a filter to convert from one type to the other. So let's say A is a string and B is a long. Then Anew = A.long() will convert A to a long.
    2. If you're using Lookup, you could actually keep the data types the same, but change the key's format within the node. So for example, using the A and B from above, you can use A.long() as either the Input/Lookup Key and then B (already a long) as the other.
    Attachments:
    matchDataTypes.brg


  • 3.  RE: Convert Long to String

    Employee
    Posted 05-08-2015 05:40

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: jchartrand

    Both worked great.

    Here I thought I would try and give you a break from the daily emails, but you found me on the forum as well!

    Appreciate the help!