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

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

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

TestNG Custom Annotations with Parameters

Perficient Digital Transformation

null) { System.out.println("Test Method: " + methodName); System.out.println("Payment Method: " + testDataAnnotation.method()); if (testDataAnnotation.method().equals("creditCard")) null) : This line checks if the @TestData annotation is present for the test method. Annotations in Java are declared using the @interface keyword.

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