I am trying to concatenate a few columns together but some of these columns have blanks/nulls -how do I do this wout picking this up/adding those in?
Hi @Hi2023
Do your columns have numeric or text values?
Can you provide some sample data inputs and a sample of your output?
1) One of doing this is to use a summarize tool and under the string option, use concatenate.
2) You can use a conditional statement with the expression IsEmpty() to set the values to 0 so they don't get concatenated.
You can also set them to a blank so they don't get added also depending on how your data is structured.
Hope this helps. If it does, please like the post.
hI @Hi2023
It would help to see a sample of your input/expected output. But maybe following these steps work for you:
1)Be sure that all fields that you are concatenating are strings
2)Clean the fields before concatenating. You can do it replacing empty cells by null cells and using the trim function to remove leading and trailing whitespaces.