Multi column split cannot be done using in strtok_split_to_table & regexp_split_to_table functions.

Teradata: Split String of Multiple Columns into table rows

Inbuilt functions strtok_split_to_table & regexp_split_to_table does not support splitting multiple columns. Custom query need to be created to get the required result.

Lets create a volatile table & populated data for illustration purpose.

CREATE VOLATILE TABLE Multicolum_split
(
Id INTEGER,
week_start_dt DATE,
days   VARCHAR(300),
hours_of_work VARCHAR(300)
)
ON COMMIT PRESERVE ROWS;

INSERT INTO Multicolum_split VALUES(1,'2020-08-31','Sun,Mon,Tue,Wed,Thu,Fri,Sat','0,9,8,8,10,8,0');
INSERT INTO Multicolum_split VALUES(2,'2020-08-31','Sun,Mon,Tue,Wed,Thu,Fri','0,5,10,8,4,7');
INSERT INTO Multicolum_split VALUES(3,'2020-08-31','Sun,Mon,Tue,Wed,Thu,Fri,Sat','0,5,10,8,4,7');


Points To be Noted: