Forum Discussion
How to add column in inner tables to outer table
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
5 Replies
Hi BA_Pete Vijay_A_Verma wdx223_Daniel AlexisOlson -
Guys please help me with above problem.
Below is my code and output -
- wdx223_Daniel
Community Champion
your column header is not "primary key", but "column 3".
you need to promote headers firstly.
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.
Hi wdx223_Daniel , Anonymous
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 :
