Remove blank
article thumbnail

How to Convert Blank Values to Null in Flat File Source in SSIS Package

Perficient Digital Transformation

In this blog we are going to learn how we convert blank values to null in flat file source. Let’s see how we Convert Blank Values to Null in Flat File Source using SSIS. Create one Flat File with Some Blank data. Here We Successfully Convert Blank Values to Null in Flat File Source. Using SSIS Package.

article thumbnail

Understanding Matching Rules in Salesforce

Perficient Digital Transformation

Note : If you check the Match Blank Fields box in front of the Email field, so it will compare the 2 blank email fields, consider them matching and eventually will give the duplicate error. Unique Name will automatically be populated. Inside the Matching Criteria, Field = Email and Matching Method = Exact. See the figure below.

professionals

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

Power BI & Excel connectivity: Scenarios which can break Dashboard

Perficient Digital Transformation

Scenario: Gaps in Data Certain times user might insert gap in data rows (typically observed for printing purpose to adjust print preview range) Power BI imports data including blank rows. Majority of the calculations would not get affected, except few DAX functions which will go on to include blank rows in calculations.

article thumbnail

Databases from the Future: What is Database Version 954?

Perficient Digital Transformation

Here it is a simple matter of running your creation script to create your blank database so Optimizely can configure it on startup. Visual Studio installs a database instance for itself, which you can see when you pull up the SQL Server Object Explorer: You can already see from the screenshot that this is a SQL 2019 instance as it is v15.

article thumbnail

Salesforce Code Collaboration: Authenticate Git with Personal Access Token and Push Code via CMD

Perficient Digital Transformation

We will also cover the process of generating a Personal Access Token, creating a blank repository on GitHub, cloning the repository, adding files, committing changes, and pushing the code. Step 2: Create a Blank Repository on GitHub: Log in to your GitHub account. Click “ Create repository ” to create the blank repository.

article thumbnail

Creating & Invoking Custom Function in Power Query

Perficient Digital Transformation

In blank area of the Queries section, right click and select new query and then blank query. After selecting the new blank query, we will be writing our custom function inside the formula bar. Step 1 : After importing the data in Power BI Desktop, go to Power BI Query editor.

article thumbnail

How to Create and Use Paginated Reports in Power BI

Perficient Digital Transformation

In this one, we can select Table Wizard/ Chart wizard/ Map Wizard / Blank Report. Here we will select Blank Report. Open Power BI Report Builder : First, we need to open Power BI Report Builder; you will see the below window.