Concatenating Database Fields

Options
Unknown
Unknown
in ? Transforming data
Is there a way to concatenate two database fields?  For example, when adding an "Eval" you can do "cities.name" as "name", then "concat" with the value of ", ".  But I would like to add a database field called "location" to the concat function.  So my result would be "Tokyo, Japan".  Any ideas?[Screen Shot 2021-12-04 at 11.44.21 AM.png]
· Share on Twitter

Comments

  • Sean Montgomery
    Sean Montgomery Administrator

    ADMIN
    Options
     it looks like you are almost doing it. You just need to do an additional concat after the first concat. You can chain the filters together.
    · Share on Twitter
  • Unknown
    Unknown
    Options
     When I do, I get the an error.  Concatenating a db field with a text field works.  Concatenating a db field, then text, then another db field causes this error.  See the screen shots below.
    [Screen Shot 2021-12-04 at 10.41.28 PM.png][Screen Shot 2021-12-04 at 10.39.35 PM.png]
    · Share on Twitter
  • Michael Udinski
    Michael Udinski Administrator

    ADMIN
    Options
     - this has now been fixed :)
    · Share on Twitter
  • Unknown
    Unknown
    Options
     does the bug I found quality for the bug bounty program?
    · Share on Twitter

Categories