Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I am appending several queries eg:
query A
query B
query C
I want to create a custom column in the append result query that will display the source query name the record was from eg:
Append results:
fruit qty source query
apple 23 query A
pear 4 query A
orange 33 query B
grapefruit 4 query B
....and so on
Solved! Go to Solution.
You may change code in The Advanced Editor.
Source = Table.Combine({Table.AddColumn(#"query A", "source query", each "query A") , Table.AddColumn(#"query B", "source query", each "query B") , Table.AddColumn(#"query C", "source query", each "query C")})
Thank you, the problem was soluted
There is a workaround using #sections now!
This is nice but, what if I have like 100 tables I need to append? How can we make this code dynamic so that it gets the table name for each row?
You may change code in The Advanced Editor.
Source = Table.Combine({Table.AddColumn(#"query A", "source query", each "query A") , Table.AddColumn(#"query B", "source query", each "query B") , Table.AddColumn(#"query C", "source query", each "query C")})
Not pretty, but it worked, thank you.
This really should be a built-in function, it would make the append query much more useful.
Thanks a lot for this. It came in very handy. I needed to combine 72 Tables for cleaning. It worked well.
Wonderful solution, thank you! Came in very handy in my work today.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
116 | |
101 | |
87 | |
35 | |
35 |
User | Count |
---|---|
152 | |
100 | |
83 | |
63 | |
54 |