合并数据在Open / Libreoffice calc [英] Merging data in Open/Libreoffice calc

问题描述

第二个数据库需要添加到第一个，但是它们有不同的数据集，只有其中一些数据重叠。

需要合并的唯一数据是已经出现在第一个的skus。 p>

例如：

---

文件1

sku，foo

a，hello

b，world

---

文件2

sku，bar

a，0

b，1

c， p>

d，3

---

将导致
sku ，foo，bar

a，hello，0

b，world，1

---

这是可能吗？

解决方案

OpenOffice：

1. 将两个数据集复制到两个不同工作表中的相同工作簿中。




2. 使用函数vlookup（与Excel中相同）在同一工作表中合并两个数据集。语法是= VLOOKUP（valueToSearchFor; tableToSearchIn; columnIdentifier; isTableSorted？）（来源）




3. 然后，您可以使用连接函数CONCATENATE（text1; text2; ... text30）将您的内容合并到单个单元格中。 （来源）

I have two sets of data in csv format which share a field called "sku".

The second one has additional columns which need to be added to the first, but they have different sets of data, only some of which overlaps.

The only data which needs to be merged is for skus which already appear in the first.

For example:

---

File 1

sku,foo

a,hello

b,world

---

File 2

sku,bar

a,0

b,1

c,2

d,3

---

Would result in sku,foo,bar

a,hello,0

b,world,1

---

Is this possible?

解决方案

In OpenOffice:

1. Copy paste your two dataset into the same workbook in two different worksheet.

2. use the function vlookup (same as in Excel) to merge your two data set in the same worksheet. The syntax is =VLOOKUP( valueToSearchFor ; tableToSearchIn ; columnIdentifier ; isTableSorted? ) (source)

3. Then you can use the concatenate function CONCATENATE(text1; text2; ... text30) to merge your content into a single cell. (source)

这篇关于合并数据在Open / Libreoffice calc的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！