Merge two columns with a separator in the middle

MH5

Hello,

I want to merge to columns from the same file with a separator in the middle '|' but I'm having an error message.

I'm using version 2019.1.6.58192 and I was working on a more recent one before with the same formula.

The expected outcome would be something like 111111|222222 (No letters)

Many thanks for the help

Workflow

Datasets

Tips and Tricks

Join

Accepted answers

Jonathan-Sherman

HI @MH5,

My guess would be at least one of your fields is a numeric data type and not a string. We can convert numeric fields to string data types using the ToString() function. For safety (and because I don't know your data types) i've wrapped both fields with the ToString() function in the below formula:

ToString([LE ID]) + "|" + ToString([ASSOCIATED_LE_ID])

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan

All comments

DiegoParker

Hi MH5,

Make sure to put your pipe in between speech marks "|" also make sure both fields are string fields.

It should be [LE ID] + "|" + [ASSOCIATED_LE_ID]

Hope this helps If does, can I ask you to mark it as the solution? this will help other users to find it and will allow us to close the thread. Many thanks!