How to add column in inner tables to outer table

[rmahadik]

Hi Experts,

I need to add a column from inner table to outer table. Can someone please guide which function can be used ?

In below snap, I want to add primary_key column to outer table 'Table_List_DB'. Please advise

[rmahadik]

Hi @wdx223_Daniel , @v-stephen-msft 

I promoted the headers and also tried to expand the nested table. However since the nested tables are not uniform in structure most of the columns are coming as null. What I want to achieve is I need only 1 column (Primary_Key) from highlighted nested table only (other tables does not contain this column) in the outer table for further manipulations. 

Source Code :

[v-stephen-msft]

Hi @rmahadik ,

The simple way is to expand the column. If you want to keep this column with tables, you can duplicate it for expansion. When you expand it,  create conditional columns to filter out the rows you need, and finally keep what you need.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rmahadik]

Below is my code and output - 

[wdx223_Daniel]

your column header is not "primary key", but "column 3".

you need to promote headers firstly.

[rmahadik]

Hi @BA_Pete @Vijay_A_Verma @wdx223_Daniel @AlexisOlson - 

Guys please help me with above problem.