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

In this blog, we’ll learn Matching Rules in Salesforce, exploring their significance and implementation. 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. So let’s get started!

professionals

Sign Up for our Newsletter

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

article thumbnail

Six Common Challenges Customer Experience (CX) Leaders Face | Blog

Everest Group

Learn what issues keep customer experience officers ( CXOs) up at night in this blog. However, this responsibility does not come with a blank check, and leaders are still challenged to reduce support costs.

article thumbnail

Power BI & Excel connectivity: Scenarios which can break Dashboard

Perficient Digital Transformation

This blog showcases few scenarios, which developer needs to take care while using Excel as data-source for Power BI report. 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.

article thumbnail

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

Perficient Digital Transformation

In this blog, we will explore the steps to login to Git using a Personal Access Token and push your code to a GitHub repository. 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.

article thumbnail

Creating & Invoking Custom Function in Power Query

Perficient Digital Transformation

In this blog, we will get introduced to custom function feature available in Power Query which is a data transformation component of Power BI Desktop. In blank area of the Queries section, right click and select new query and then blank query. Let’s Dive.

article thumbnail

Mastering Salesforce Queues: A Step-by-Step Guide

Perficient Digital Transformation

In the previous part of this blog, we discussed “What is Salesforce Queue?” In this blog post, we’ll learn how to create Queues in Salesforce, and how we can add users or members as well as assign records to them. If not, you’ll see a blank list. We have already discussed them in the previous part of this blog.