In this tutorial, we will learn how to remove duplicate records from the file using Talend Open Studio Designer or how to store unique records from a file in Talend.
Components Used : tFileOutputDelimited, tFileInputDelimited and tUniqRow
The requirement is to read a source csv file having duplicate records. In this demo tutorial, we will read data from a file having duplicates and store unique records in a separate file and duplicate records in another file.
...
https://www.youtube.com/watch?v=yIRgFT2dRTA
In this video of SSRS Tutorial, You will be learning How to add Dates parameters in SSRS Report to organise and visualise your data in a better manner.
SSRS gives developers the ability to add custom code to their report layouts. Matrices provide functionality similar to cross-tabs and pivot tables. After our initial design, we can continue to develop a matrix to improve the viewing experience for the user.
The Adjacent grouping functionality can be used to create separate groupings in the same table. These groups, while created in the same table, don't depend on each other.
To learn more - please visit us as http://www.sql-datatools.com
...
https://www.youtube.com/watch?v=3uB1FtMgJDg
In this video of SSRS Tutorial, You will be learning How to create Multiple (Cascading) Parameterised Report in SSRS. Cascading parameters provide a way of managing large amounts of report.
To learn more - please visit us as http://www.sql-datatools.com
...
https://www.youtube.com/watch?v=8SHIwpecO8I
In this tutorial, we will learn "How to calculate the Descriptive Statistics in the dataset by using Input tool and Field Summary tool" in Alteryx tool.
The Field Summary tool analyzes data and creates a summary report containing descriptive statistics of data in selected columns. Use the Field Summary Tool to gain insight into data and receive recommendations for managing data.
Numeric, string, spatial, and date/time are supported in this tool. A unique set of descriptive statistics are provided for each data type. See Data Types for more on types of data.
Descriptive Summary - It is used to show descriptive statistics like mean, median, mode, max, min, etc. It is generally used to understand the distribution of the variables present in the data. In Alteryx, choose the Field summary tool from the Data investigation tab in order to calculate the descriptive statistics of all the variables present in the data set.
To learn more, please follow us -
http://www.sql-datatools.com
To Learn more, please visit our YouTube channel at -
http://www.youtube.com/c/Sql-datatools
To Learn more, please visit our Instagram account at -
https://www.instagram.com/asp.mukesh/
To Learn more, please visit our twitter account at -
https://twitter.com/macxima
To Learn more, please visit our Medium account at -
https://medium.com/@macxima
...
https://www.youtube.com/watch?v=301E3tbEBno
In this tutorial, we are going to explain the functionalities of Execute Package Task to call multiple child packages in SQL Server Integration Services.
The Execute Package task extends the enterprise capabilities of Integration Services by letting packages run other packages as part of a workflow.
For more information, please visit us at http://www.sql-datatools.com/2016/04/ssis-object-types-variable-in-execute.html
...
https://www.youtube.com/watch?v=RP-Fy09k_Cc
In this tutorial, we will learn "How to Create Column Based Drill Down Report" in ssrs.
A Column Drill Down report is similar to row drill report but main difference is that it’s based on the columns and will provide the additional details of the column summary.
For example; sales admin wants to see the performance of the each item in last 5 years. If he is also interested to know the performance of the sales person for those items in the same year then this kind of the report will be very helpful to represent the requested information.
To learn more, please visit us at -
http://www.sql-datatools.com
...
https://www.youtube.com/watch?v=gJNxc3cVlbw
In this tutorial, you will learn "How to apply nested lookup functions on your report" in ssrs.
So, a very simple way to accomplish this is to place a field on your report (TextBox1.value) that will hold your first lookup value. If you don't want to show the first level value then you can hide it from the report.
For example, your first look up will return a vendor ID (dsSalesOrders) from a customer order (dsCustomers).
But now you need to find the vendor name from a Vendor Master table (dsVendors). You can do another look up to the Vendor Master table using the ReportItems!TextBox1.value (Hidden field on the report) as the first value of the look up. That way you do not get the scope issue.
To learn more, please follow us -
http://www.sql-datatools.com
To Learn more, please visit our YouTube channel at -
http://www.youtube.com/c/Sql-datatools
To Learn more, please visit our Instagram account at -
https://www.instagram.com/asp.mukesh/
To Learn more, please visit our twitter account at -
https://twitter.com/macxima
...
https://www.youtube.com/watch?v=vmKpc25wbY0