September 28, 2017 at 2:26 pm
river1 - Thursday, September 28, 2017 2:12 PMI mean, I need to find a way to replace the null for the name is order to be able to generate the aggregate without having two results.
As indicated, you'll have to write a SQL query to derive that information, and then you can merge it with the existing raw source data, based on the grouping fields matching. A derived column transformation can then choose which field to take to build the new (or it can replace the old) Manager Name column.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
September 28, 2017 at 11:28 pm
Hello,
Thank you for your reply. Problema. Is that the Soure file is excel, not sql. So I cannot build a sql task
September 29, 2017 at 5:53 am
river1 - Thursday, September 28, 2017 11:28 PMHello,Thank you for your reply. Problema. Is that the Soure file is excel, not sql. So I cannot build a sql task
What is the target?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
September 29, 2017 at 5:58 am
river1 - Thursday, September 28, 2017 11:28 PMHello,Thank you for your reply. Problema. Is that the Soure file is excel, not sql. So I cannot build a sql task
In that case, the right way to do this is to import that data directly into a staging table with rows and columns intact.
Then you can write a query to transform the data in that staging table into something you can actually use. Alternatively,
you may be able to just use the staging table as a source for a reporting query that delivers the data to an SSRS report.
I don't recall you mentioning an Excel source in your initial post, so please try to be more thorough in your problem descriptions,
as that will help us help you more quickly. Had we known it was an Excel source, we could have avoided several posts
back and forth. As we are not right there beside you, we can't know what you don't tell us...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply