Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
hopefully someone can guide me in the right direction?
i have a query whcih results in this data like this:
firstName | lastName | course | attendedSessionOne | |
joe | bloggs | j.gloggs@example.com | maths | no |
adriana | frank | a.frank@example.com | english | yes |
jaci | sadler | j.sadler@example.com | science | no |
kirk | gregory | k.gregory@example.com | science | no |
brandie | tatum | b.tatum@example.com | maths | yes |
mortimer | riley | m.riley@example.com | english | yes |
So the above would show a course and who attended the fisrt session
I then also have a query that shows the information to session 2 as follows:
firstName | lastname | course | attendedSessionTwo | |
joe | bloggs | j.bloggs@example.com | maths | yes |
jaci | sadler | j.sadler@example.com | science | no |
kirk | gregory | k.gregory@example.com | science | yes |
mortimer | riley | m.riley@example.com | english | no |
What i'm trying to achieve is to add a column in the first query that looks up the course and the identifier for the person (email address) from the second table and say if they attended the second session or not - if they don't appear in the second query, then the default should be no.
So, looking at the above two queries, i should have a final peice of data that looks like the below:
firstName | lastName | course | attendedSessionOne | attendedSessionTwo | |
joe | bloggs | j.gloggs@example.com | maths | no | yes |
adriana | frank | a.frank@example.com | english | yes | no |
jaci | sadler | j.sadler@example.com | science | no | no |
kirk | gregory | k.gregory@example.com | science | no | yes |
brandie | tatum | b.tatum@example.com | maths | yes | no |
mortimer | riley | m.riley@example.com | english | yes | no |
Hopefully i'm exaplining it OK - please let me know if not and i'll provide more information if i can.
Cheers,
J
Solved! Go to Solution.
Hi @7jaydub9
Download PBIX file with the example shown below
With those 2 queries (tables) in Power Query, you can merge them and pull the attendedSessionTwo column into Query1.
Immediately after merging the new column will contain a Table. You just expand these tables (click the double headed arrow at the top of the column) and only extract the attendedSessionTwo column
Where there are peopel who did not atend Session 2, you'll have a null. If you right click on the column header and choose Replace value you can replace these nulls with no
Regards
Phil
Proud to be a Super User!
No worries 🙂
Proud to be a Super User!
Hi @7jaydub9
Download PBIX file with the example shown below
With those 2 queries (tables) in Power Query, you can merge them and pull the attendedSessionTwo column into Query1.
Immediately after merging the new column will contain a Table. You just expand these tables (click the double headed arrow at the top of the column) and only extract the attendedSessionTwo column
Where there are peopel who did not atend Session 2, you'll have a null. If you right click on the column header and choose Replace value you can replace these nulls with no
Regards
Phil
Proud to be a Super User!