Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

How to combine 2 columns in to a single column

Hi,

 

i have following table

 

Employee_Name       Join_Date         Department_Join Date

 

   Neema                     25-04-2018                  04-05-2018

   Olga                        15-05-2018                   27-08-2018

 

 

I Expect as following table

 

Employee_Name                     Date

  Neema                                   25-04-2018 

  Neema                                   04-05-2018

  Olga                                       15-05-2018

  Olga                                       27-08-2018     

 

how can i acheive this?

 

1 ACCEPTED SOLUTION
slanka
Helper I
Helper I

Hi,

 

To achieve this, you need to Unpivot the table data. 

Unpivot.gif

View solution in original post

3 REPLIES 3
slanka
Helper I
Helper I

Hi,

 

To achieve this, you need to Unpivot the table data. 

Unpivot.gif

Aron_Moore
Solution Specialist
Solution Specialist

In query editor; load it as two tables, then append the the tables.

Anonymous
Not applicable

i have 3 columns in a single table.

how can i append 2 columns into a single column within a table

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.