Remove null
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. It will load data from flat file to table, but it will load blank data in string columns and zero in integer columns, but we want Null value instead of blank value.

article thumbnail

Content Delivery – Removing necessary fields and how to add new fields to the API response

Perficient Digital Transformation

To filter the API response and remove the fields that you don’t need and/or remove the null field to get the nicer and clearer output you need to use IContentApiModelFilter which is explained in the Optimizely documentation. With Optimizely you can implement your headless solution using the Content Delivery API.

professionals

Sign Up for our Newsletter

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

article thumbnail

How to create custom Cascading Dropdown List element in Sitecore Form.

Perficient Digital Transformation

null) { label.SetValue(SecondDropListLabel, true); } var value = item.Fields["SecondDropListValue"]; if (value != null) { value.SetValue(SecondDropListValue, true); } var text = item.Fields["SecondDropListText"]; if (text != null) { text.SetValue(SecondDropListText, true); } } } } Step 3: Create a view for binding the Model values.

Design 105
article thumbnail

Anchor/Jump Links – Simple Example, but Useful

Perficient Digital Transformation

null) { var jumpLinkItems = currentContent.MainContentArea.FilteredItems.GetContentItems<IJumpLinkable>(); var links = new Dictionary<string, string>(); foreach (var jumpLinkItem in jumpLinkItems.Where(jumpLinkItem => ! W3School Anchor example ) Rendering the Navigation Menu: if (Model.JumpLinks !=

article thumbnail

Overriding Optimizely’s Content Recommendations Block to Implement Custom Recommendations

Perficient Digital Transformation

null && !string.IsNullOrEmpty(cookieVal) Since the delivery widget is necessary to interfacing with the API, we return null and handle any empty recommendations list within the view. Value; //build url var url = $"{_ApiUrl}{(cookieVal != string.IsNullOrEmpty(cookieVal) ?

105
105
article thumbnail

Make Your Flutter Apps Soar with Pigeon Platform Channels

Perficient Digital Transformation

textAlign: TextAlign.center, child: FutureBuilder<String>( future: exampleApi.getString(), // a previously-obtained Future<String> or null builder: (BuildContext context, AsyncSnapshot<String> snapshot) { List<Widget> children = []; if (snapshot.data! textTheme.displayMedium!, textTheme.displayMedium!,

article thumbnail

SQL Magic Series – Minus Sign in ORDER BY

Perficient Digital Transformation

Before answering that, let’s see, how ORDER BY works without MINUS: ORDER BY emp_no DESC ; If you end the relevant query this way, you will obtain an output ordered with the highest employee number on top, the lowest employee number down the list, and the null values at the end. the top part of the output has been displayed.