Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi,
This forum post explains how to create a table from a list and specify the column name;
and this useful blog by @Rickmaurinus explains how to create tables based on adding rows.
However, I am looking to create a table by glueing columns together where each column receives its value from a given list.
Example, say that I have two lists of 5 elements each,
By using Power Query functions and the above lists as input, how can I obtain the following table?
ID1 | ID2 |
A | 1 |
B | 2 |
C | 3 |
D | 4 |
E | 5 |
I have tried variations on the following:
Source = Table.Combine(
Table.FromList(listA,Splitter.SplitByNothing(),{"ID1"}),
Table.FromList(listB,Splitter.SplitByNothing(),{"ID2"})
)
However, Table.Combine( ) works only by adding rows together, so the above throws an error.
No doubt that there is an easy and elegant way forward, but I can't seem to find it.
Solved! Go to Solution.
Source=Table.FromColumns({ListA,ListB},{"ID1","ID2"})
Thank you. Elegant and simple.
Source=Table.FromColumns({ListA,ListB},{"ID1","ID2"})
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.