Split column on Data Types

Question

Split column on Data Types

yrstruly

Hall of Fame

Points: 3475
More actions
March 28, 2022 at 1:05 pm

#4007035

Please assist? I would like to split column Event in two columns based on data types.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Thom A SSC Guru Points: 99133 More actions · Answer 1

Images of data aren't going to help us help you. Post the data as DDL and DML statements. Also explain the problem, what are you expected results here? What have you tried to solve as well, so we can help explain why what you've tried isn't working. As you've poated in the Integration Services Forum, I assume you're looking for a solution using SSIS? Does this mean you need achieve this using transformations in a Data Flow Task, or are you looking to do with an Execute T-SQL task?

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

Phil Parkin SSC Guru Points: 246985 More actions · Answer 2

>3,000 points and all you provide is a screenshot? You should know better.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

ratbak Ten Centuries Points: 1381 More actions · Answer 3

Looks like a repeat of

https://www.sqlservercentral.com/forums/topic/pivot-split-column and

https://www.sqlservercentral.com/forums/topic/pivot-split-column-2 and

https://www.sqlservercentral.com/forums/topic/pivot-split-column-3

yrstruly Hall of Fame Points: 3475 More actions · Answer 4

I would like to split Event column based on data type as shown in Data type column.

USE [IT]

GO

/****** Object: Table [dbo].[Journey_Event_Value$] Script Date: 2022/03/28 21:15:30 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Journey_Event_Value$](

[Feed_2_Unique_ID] [nvarchar](255) NULL,

[Date] [datetime] NULL,

[DV360_Line_Item_ID] [float] NULL,

[Value] [float] NULL,

[Event] [nvarchar](255) NULL,

[Journey] [nvarchar](255) NULL,

[Slide] [nvarchar](255) NULL,

[Type] [nvarchar](255) NULL,

[Data Types] [nvarchar](255) NULL,

[F10] [nvarchar](255) NULL,

[F11] [nvarchar](255) NULL,

[F12] [nvarchar](255) NULL

) ON [PRIMARY]

GO

Thom A SSC Guru Points: 99133 More actions · Answer 5

yrstruly wrote:

I would like to split Event column based on data type as shown in Data type column.

That sentence honestly makes no sense and doesn't explain anything. To repeat myself:

Explain the problem, what are you expected results here? What have you tried to solve as well, so we can help explain why what you've tried isn't working. As you've posted in the Integration Services Forum, I assume you're looking for a solution using SSIS? Does this mean you need achieve this using transformations in a Data Flow Task, or are you looking to do with an Execute T-SQL task?

You didn't answer any of these questions, you just gave the DDL (of the DDL and DML) part of your table; that isn't enough; as must as you wish we could, we can't read your mind. If you can't explain the problem, then you need to go and work out what it is you want first. If you don't understand the problem you will have no chance of explaining it to someone else.

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk