Place summary data in main table

[#1]

Hello,

I have a summary table and would like to transfer part of the data into the non-summarised table (see attachment).

Value C1 would be transferred to all rows that have values A1 and B1 in columns A and B respectively. 

I have tried Rows > "Join" and "Update" but I can't find the result I need.

Would you know how to perform this new column?

Thank you in advance for your support!

Best
Claire

[#2 · Accepted solution]

Hi Claire,

It should be possible to do this with a table join. You just need to specify A and B as your matching columns.

You can also do this with a click-and-drag operation from the summary table to the original table:

Drag Summary Column.mp4

Video Player is loading.

Play Video

Play

Mute

Current Time 0:00

/

Duration 0:07

Loaded: 0%

0:00

Stream Type LIVE

Seek to live, currently behind liveLIVE

Remaining Time -0:07

1x

Playback Rate

Chapters

• Chapters

Descriptions

• descriptions off, selected

Captions

• captions settings, opens captions settings dialog
• captions off, selected

Audio Track

• default, selected

Picture-in-PictureFullscreen

This is a modal window.

Beginning of dialog window. Escape will cancel and close the window.

Text

ColorWhiteBlackRedGreenBlueYellowMagentaCyanTransparencyOpaqueSemi-Transparent

Background

ColorBlackWhiteRedGreenBlueYellowMagentaCyanTransparencyOpaqueSemi-TransparentTransparent

Window

ColorBlackWhiteRedGreenBlueYellowMagentaCyanTransparencyTransparentSemi-TransparentOpaque

Font Size

50%75%100%125%150%175%200%300%400%

Text Edge Style

NoneRaisedDepressedUniformDropshadow

Font Family

Proportional Sans-SerifMonospace Sans-SerifProportional SerifMonospace SerifCasualScriptSmall Caps

Reset restore all settings to the default valuesDone

Close Modal Dialog

End of dialog window.

Close Modal Dialog

This is a modal window. This modal can be closed by pressing the Escape key or activating the close button.

Click and hold on the column header for the summary column, wait, then drag and drop into the column header for the first unused column in the original table.

I hope this helps,

Phil

[#3]

Hi Phil,

Thank you so much for the quick reply!

Below in orange my answers to your message.

Best,

Claire

Hi Claire,

It should be possible to do this with a table join. You just need to specify A and B as your matching columns.

This works! Thank you!!

You can also do this with a click-and-drag operation from the summary table to the original table:

Click and hold on the column header for the summary column, wait, then drag and drop into the column header for the first unused column in the original table.

When I do this, it copies the column of my summary table into the new column but does not copy according to matching columns (I have the same number of rows filled in the new column as in the summary table).

I hope this helps,

Phil

[#4]

Okay. I am glad that the table join worked. I am not sure why the click-and-drag option did not work. I don't know how it works out how to match the columns. I think that the summary table needs to be linked to the original data table, which it will be by default if you use Tables > Summary. If the tables are linked then the columns in the summary table should have "padlock" icons next to them: