Teradata 13.10 Replication of Array Logic

Database

Teradata 13.10 Replication of Array Logic

Hello, I am having difficulty storing multiple column values within the same row, since I am unable to group by only the identifying value, according to the sample code below, "ID." I believe creating an array for each unique ID would solve this problem, but I am using Teradata 13.10, and the array UDF is not supported within this version.

Select 
a.ID,
a.column_1,
a.column_2,
a.column_3,
a.column_4,
a.column_5,
a.column_6,
b.column_1

From
Table_a a

inner join Table_b
     on a.ID = b.ID;

Is there any way that I can replicate array logic that will allow the storage of multiple string values within only one record per ID value?

Thanks,

Eric

Tags (1)