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
mokrane_bob
Frequent Visitor

Get two column with value from another column

Hello,

 

It's simple what i want to do but i can't reach it.

I have this 

Capture.PNG

Now i want to have two columns which will be filled according to the colomn source.

If the type is Newsletter => this will be filled in the new column for Newsletter.
if the type is Enquête => this will be filled in the new column for Enquête

Capture2.PNG

Thank you

1 ACCEPTED SOLUTION
Arul
Super User
Super User

Hi @mokrane_bob ,

You have to do this applied steps in your edit queries.

Screenshot (21).png

 

Go to edit queries and then,

1.Duplicate that column

2.Promote first row as headers

3.Replace value for column 1

4.Replace value for column 2

 

Regards,

-Arul





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


View solution in original post

1 REPLY 1
Arul
Super User
Super User

Hi @mokrane_bob ,

You have to do this applied steps in your edit queries.

Screenshot (21).png

 

Go to edit queries and then,

1.Duplicate that column

2.Promote first row as headers

3.Replace value for column 1

4.Replace value for column 2

 

Regards,

-Arul





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


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.