How to do column splitting in power bi using delimiter

This recipe helps you to do column splitting in power bi using delimiter

Recipe Objective - How to do column splitting in power bi using delimiter

Step 1 - What is a delimiter?

Splitting using delimiter means we can split the columns by using delimiters which can be:

"Comma" "," "Colon" ";" "Space" " " "Semi-colon" ":" "Custom" in this we can add delimiter as per our data

Note - The dataset that we are going to use is the Customer details dataset which consists of two columns Customer ID and Customer Name.

Step 2 - Go to the data pane

On the left-hand side of the window, there are 3 options present select the second one which is a data pane then select the column which you want to split, right-click on it and select Edit Query which will redirect you to the Power query editor.

Step 3 - Split column

In the Power Query editor in the Home tab, there is an option available "Split Column" click onto that option and a new window will be opened up which will show you the options for splitting the column, then select the delimiter by which you want to split the column in our case we are using "space" delimiter after that select from where you want to split it like the "left-most", "right-most", and "Each occurrence" in our case we are selecting the "left-most". At last click on OK and a new column will be generated with the split values in it.

What Users are saying..

profile image

Savvy Sahai

Data Science Intern, Capgemini
linkedin profile url

As a student looking to break into the field of data engineering and data science, one can get really confused as to which path to take. Very few ways to do it are Google, YouTube, etc. I was one of... Read More

Relevant Projects

Build CI/CD Pipeline for Machine Learning Projects using Jenkins
In this project, you will learn how to create a CI/CD pipeline for a search engine application using Jenkins.

Multilabel Classification Project for Predicting Shipment Modes
Multilabel Classification Project to build a machine learning model that predicts the appropriate mode of transport for each shipment, using a transport dataset with 2000 unique products. The project explores and compares four different approaches to multilabel classification, including naive independent models, classifier chains, natively multilabel models, and multilabel to multiclass approaches.

FEAST Feature Store Example for Scaling Machine Learning
FEAST Feature Store Example- Learn to use FEAST Feature Store to manage, store, and discover features for customer churn prediction machine learning project.

Deploy Transformer-BART Model on Paperspace Cloud
In this MLOps Project you will learn how to deploy a Tranaformer BART Model for Abstractive Text Summarization on Paperspace Private Cloud

Deep Learning Project for Time Series Forecasting in Python
Deep Learning for Time Series Forecasting in Python -A Hands-On Approach to Build Deep Learning Models (MLP, CNN, LSTM, and a Hybrid Model CNN-LSTM) on Time Series Data.

Learn Object Tracking (SOT, MOT) using OpenCV and Python
Get Started with Object Tracking using OpenCV and Python - Learn to implement Multiple Instance Learning Tracker (MIL) algorithm, Generic Object Tracking Using Regression Networks Tracker (GOTURN) algorithm, Kernelized Correlation Filters Tracker (KCF) algorithm, Tracking, Learning, Detection Tracker (TLD) algorithm for single and multiple object tracking from various video clips.

NLP Project to Build a Resume Parser in Python using Spacy
Use the popular Spacy NLP python library for OCR and text classification to build a Resume Parser in Python.

Learn to Build a Neural network from Scratch using NumPy
In this deep learning project, you will learn to build a neural network from scratch using NumPy

AWS MLOps Project for Gaussian Process Time Series Modeling
MLOps Project to Build and Deploy a Gaussian Process Time Series Model in Python on AWS

Build ARCH and GARCH Models in Time Series using Python
In this Project we will build an ARCH and a GARCH model using Python