Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Good morning 🙂,
I have a database with steps applied to it on Power Query, I would like to add one last step to:
duplicate all the rows of my table whose "Account number" column begins with 6 or 7. I'll give you an example of what I want with a before and after:
Code | Category | Account number | Data |
1 | A | 600000 | E |
3 | B | 700000 | D |
3 | C | 100000 | C |
4 | E | 200000 | G |
Desired result :
Code | Category | Account number | Data |
1 | A | 600000 | E |
3 | B | 700000 | D |
3 | C | 100000 | C |
4 | E | 200000 | G |
1 | A | 600000 | E |
3 | B | 700000 | D |
Thank you for your help
Solved! Go to Solution.
Say you are at step name FullTable. Just filter to include only the accounts you want to duplicate, name this step Filtered, and then
= Table.Combine({FullTable, Filtered})
You can refer to any step in any order.
--Nate
Hi Power_BI_new,
I put together your example provided to show you how I achieved this differently than the other suggestions.
So once I put together the data in an xlsx file, I started with the sample below. Please note that I had formatted the "Account Number" column as text.
So the first step was that I clicked the "Add Step" button to create a starting point and named the new step, "--original_data".
Then I used a filter on the "Account Number" column, using the text filter begins with a 6 or 7.
Then I appended the current query onto itself.
Then as the last step, when you select the append query step it will show the name of the query twice. So I changed one of those names to the "--original_data" step name, that I name in the first step.
from:
to:
This is my final result, which I believe matches what you are trying to acheive.
If I'm not coming accross clearly, happy to share the pbix file I put together if you have somewhere I can drop it 🙂
If you need to, you can change the account number back to a whole number format.
Hi Power_BI_new,
I put together your example provided to show you how I achieved this differently than the other suggestions.
So once I put together the data in an xlsx file, I started with the sample below. Please note that I had formatted the "Account Number" column as text.
So the first step was that I clicked the "Add Step" button to create a starting point and named the new step, "--original_data".
Then I used a filter on the "Account Number" column, using the text filter begins with a 6 or 7.
Then I appended the current query onto itself.
Then as the last step, when you select the append query step it will show the name of the query twice. So I changed one of those names to the "--original_data" step name, that I name in the first step.
from:
to:
This is my final result, which I believe matches what you are trying to acheive.
If I'm not coming accross clearly, happy to share the pbix file I put together if you have somewhere I can drop it 🙂
If you need to, you can change the account number back to a whole number format.
Thank you very much for this detailed answer!
Say you are at step name FullTable. Just filter to include only the accounts you want to duplicate, name this step Filtered, and then
= Table.Combine({FullTable, Filtered})
You can refer to any step in any order.
--Nate
Thank you for your answer, but it gives me this error:
Sorry... We couldn't convert a value of type Table to type List:
Details :
Value = [ Table ]
Type = [ Type ]
Most likely you entered the code incorrectly, omitting the "{..}" around the List of tables
Works perfectly!!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
24 | |
12 | |
12 | |
11 | |
7 |
User | Count |
---|---|
43 | |
28 | |
14 | |
13 | |
13 |