There is one scenario where I am struggling to implement a logic in Teradata, I have a table as shown below.

I’m trying to use STRTOK_SPLIT_TO_TABLE in teradata to split space delimited column into multiple rows. All other column values should be repeated in the new rows. I can’t find anywhere in TD reference to accomplish this. Any thoughts?

I’m trying to use STRTOK_SPLIT_TO_TABLE in teradata to split space delimited column into multiple rows. All other column values should be repeated in the new rows. I can’t find anywhere in TD reference to accomplish this. Any thoughts?

I’m trying to use STRTOK_SPLIT_TO_TABLE in teradata to split space delimited column into multiple rows. All other column values should be repeated in the new rows. I can’t find anywhere in TD reference to accomplish this. Any thoughts?

I’m trying to use STRTOK_SPLIT_TO_TABLE in teradata to split space delimited column into multiple rows. All other column values should be repeated in the new rows. I can’t find anywhere in TD reference to accomplish this. Any thoughts?

I’m trying to use STRTOK_SPLIT_TO_TABLE in teradata to split space delimited column into multiple rows. All other column values should be repeated in the new rows. I can’t find anywhere in TD reference to accomplish this. Any thoughts?

I am using Teradata and there is a scenario which I am not sure how to achieve it using sql query. I have a table with data as given below. The table is grouped based on the columns GP,Key1,Key2 and Key3. Now my requirement is that, I need to populate the start date from the column process date, for few of the ID.

Teradata SQL: How can I group my dates to week ending Sunday?
E.g. 26-Jul-24, 27-Jul-24, 28-Jul-24 will be grouped as 28-Jul-24.
I tried TD_SUNDAY and TD_WEEK_END but couldn’t quite get the results I want.

Summary

Sorry i am new to SQL and was wondering if there exists a means to returns a default value for record that do not exist. e.g. select * from tables where col1 in (1,2,3) in this case 2 does not exists in the table