Hi, thanks for these tech videos. your videos are easily understandable. I just have a doubt. i have a date column starts from 2011-01-01 and ends at 2011-12-30. I want to split the whole data into 2 half year by applying conditional split on date column. can you pls help me in this? Eg: I want to split data from 2011-01-01 to 2011-06-30 and move to one database and another half to another database. I have been trying with the formulas to split but I could not get the correct formula.
I will try to add the data in description of it exist. But, I suggest you can create your own dataset and practice. Creating the dataset is one of the skills required for data analytics
Hi Nags, In my case Conditional split is working in opposite manner .. for eg. if I have to select all the transaction done by SalesPersonID == 277 then I need to provide case as SalesPersonID != 277 and then it is loading correct data. When I give condition as SalesPersonID == 277 it loads all the data where SalesPersonID is not equals to 277. Can you help me with this ?
The way explaining is amazing even hard concept has becomes simple to me.. thanks for precious content!!
Thanks keep learning
Very nicely presented.
Thank you! Cheers!
If we want to use multiple cases under conditional split how to do?
nice explanation..
Thanks for liking
really great contents in order to hands on can you share Data set or csv files of sales data in this series
Check
Description
what is the use of script task and when should we use
Will make video on the topic
Hi, thanks for these tech videos. your videos are easily understandable. I just have a doubt.
i have a date column starts from 2011-01-01 and ends at 2011-12-30. I want to split the whole data into 2 half year by applying conditional split on date column. can you pls help me in this?
Eg: I want to split data from 2011-01-01 to 2011-06-30 and move to one database and another half to another database. I have been trying with the formulas to split but I could not get the correct formula.
Create a conditional column based on that date and. Redirect the two outputs to different target
Hi can you share script of the sales file you have been creating for the transformation so that we can also do this on our system while watching it.
I will try to add the data in description of it exist.
But, I suggest you can create your own dataset and practice. Creating the dataset is one of the skills required for data analytics
@@AnalyticswithNags totall agree with you but my point is creating table structure is not a issue but adding data points to it is the main catch here.
Hi Nag,
Can you please share the SSIS Tutorial vdo(6/25) link..
ruclips.net/video/TPaOSWkAZ3g/видео.html
You can refer to channel page and check the SSIS playlist as well instead of searching one by one
Hi Nags,
In my case Conditional split is working in opposite manner .. for eg. if I have to select all the transaction done by SalesPersonID == 277 then I need to provide case as SalesPersonID != 277 and then it is loading correct data. When I give condition as SalesPersonID == 277 it loads all the data where SalesPersonID is not equals to 277. Can you help me with this ?
I hope 277 is treated as number. Use within quotes '277' and then try
7/25
Not sure why you comment numbers from the video