Forum Discussion

deboec's avatar
deboec
Helper I
5 years ago
Solved

Fill blanks in table with values from other table

I have 2 Excel files with one table each. One table contains data with >500 rows and specific columns.  There are blank values in one importanct column for me in this table which need to be filled....
Need Help
  • ERD's avatar
    ERD
    5 years ago

    Hi deboec ,

    As far as I understand, you need to get Project column value and it can be looked up by Id column.

    1. Merge queries in your first table, use Id columns in both tables, Left Outer join kind.

    2. Enpand the needed column (Project).

    3. Does your second table contain ONLY missing values from the first one?

    If so, you can Merge these columns (choose 2 columns: initial Project column & merged Project column), click Transfrom > Merge Columns.

    If not, click Add Column > Custom Column and 

    if [Project] = "" then [T2.Project] else [Project]

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

ERD's avatar
ERD
Community Champion
5 years ago

Hi deboec ,

As far as I understand, you need to get Project column value and it can be looked up by Id column.

1. Merge queries in your first table, use Id columns in both tables, Left Outer join kind.

2. Enpand the needed column (Project).

3. Does your second table contain ONLY missing values from the first one?

If so, you can Merge these columns (choose 2 columns: initial Project column & merged Project column), click Transfrom > Merge Columns.

If not, click Add Column > Custom Column and 

if [Project] = "" then [T2.Project] else [Project]

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