Merging data in Open/Libreoffice calc

问题:

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?

回答1:

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)