I am trying to concatenate BLOCK_ID1 and BLOCK_ID2 into one string in BLOCK_ID. I want to remove the last comma in the string.

MyDE

When i do:

SELECT UNIQUE_ID,
CONCAT(BLOCK_ID1,', ', BLOCK_ID2) as BLOCK_ID
From MyDE

OUTPUT DE:

I want to remove the last comma from C

I am trying to concatenate BLOCK_ID1, BLOCK_ID2 and BLOCK_ID3 into one string in BLOCK_ID. I want to remove the last comma in the string.

MyDE

When i do:

SELECT UNIQUE_ID,
CONCAT(BLOCK_ID1,', ', BLOCK_ID2, ', ', BLOCK_ID3) as BLOCK_ID
From MyDE

OUTPUT DE:

I want to remove the last comma from B and C

I want to concatenate some fields in one string with a comma as a delimiter, but want to omit the blank values.

MyDE

When i do:

SELECT UNIQUE_ID,
CONCAT(BLOCK_ID1,', ', BLOCK_ID2) as BLOCK_ID
From My DE

OUTPUT DE:

I want to remove the last comma from my output DE

I am trying to concatenate BLOCK_ID1 and BLOCK_ID2 into one string in BLOCK_ID. I want to remove the last comma in the string.

MyDE

When i do:

SELECT UNIQUE_ID,
CONCAT(BLOCK_ID1,', ', BLOCK_ID2) as BLOCK_ID
From MyDE

OUTPUT DE:

I want to remove the last comma from C

I want to concatenate some fields in one string with comma as a delimeter, but want to omit the values that are blank.

MyDE | UNIQUE_ID | BLOCK_ID1 | BLOCK_ID2 | |:---- |:------:| -----:| | A | 1 | 2 | | B | 1 | 2 | | C | 1 | |

When i do:

SELECT UNIQUE_ID,
CONCAT(BLOCK_ID1,', ', BLOCK_ID2) as BLOCK_ID
From My DE

OUTPUT DE: | UNIQUE_ID | BLOCK_ID | |:---- |:------:| | A | 1, 2, | | B | 1, 2, | | C | 1, |

I want to remove the last comma from my output DE

I want to concatenate some fields in one string with a comma as a delimiter, but want to omit the blank values.

MyDE

When i do:

SELECT UNIQUE_ID,
CONCAT(BLOCK_ID1,', ', BLOCK_ID2) as BLOCK_ID
From My DE

OUTPUT DE:

I want to remove the last comma from my output DE