SOLVED

How do I only expand the first row of a table?

Occasional Contributor

Hi!

 

I only want to return the first result from each table from each row. How do I do this? Some tables only have 1 item, others have 4 or more, the first is always the one I want.

1.png

Formula after I expand the tables:

 

= Table.ExpandTableColumn(#"Expanded Device", "NetworkInterface", {"sNetworkAddress", "sNetworkName"}, {"sNetworkAddress", "sNetworkName"})

 

Picture to match formula:

2.png

Thanks!

1 Reply
best response confirmed by dlprentice (Occasional Contributor)
Solution

You can add a custom column with the formula
Table.First([Networkinterface])
Expand this new column.
Or you can integrate Table.First() in you a.m. formula.