Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi POwer query superstars,
I have a nice problem for you.
Is it possible to combine a table
Ex: #"The headers i Need"
With each tables like here below
In order to get all the headers from
#"The headers i Need"
into each tables
?
😛
Hi @SebSchoon1 ,
I am not sure if I understood your question correctly. If you simply want to merge all tables in this list into one table, please try using the Table.Combine function.
combine = Table.Combine(#"Previous Step Name"[#"All rows"])
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Do you mean like this:
Table.TransformColumns(
#"Previous Step Name",
{{"all rows", each Table.Combine({#"The headers i Need", _}), type table}}
)
If you want you can promote headers in the same step
each Table.PromoteHeaders(Table.Combine({#"The headers i Need", _}))
Hello, @AlexisOlson Sorry for late reply i was on vacation 👌
I'll try this asap and keep you posted!
So many thanks for your reply!
I have been able to manage it creating a function. Then
= Table.Combine(Table.AddColumn(#"Colonnes supprimées1", "Personnalisé", each Fusion_entetes_groupes([all rows])))
However this is extremely slow.
any advice?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.