Forum Discussion

andre_mangatal's avatar
andre_mangatal
New Contributor
7 years ago

Converting String to Bigint

Good day SnapLogic Community

Is there a function that accepts a string and converts it to a BigInt? An equivalent SQL statement is below,

CAST(DRIVERPERMIT AS BIGINT) = 0

Thank you very much in advance,
Andre

1 Reply

  • Sowmya_Rayavara's avatar
    Sowmya_Rayavara
    New Contributor III

    Hi Sunil,

    Read two files and use join snap to get the desired output.
    This is the similar use case as yours.I have used left outer join as per my requirement. You can use any other join.
    Check this sample pipeline to get more clarity.

    • mithsrini's avatar
      mithsrini
      New Contributor II

      Hi Sowmya,

      This is helpful. Thanks for sharing.

      Thanks,
      Mithila JT