Hi, I am trying to merge 2 datasets with the same categories, but different sub-categories into one with all sub-categories. Here I attach sanitized examples of the datasets I would like to merge, and the desired output: Dataset to merge 1 (2019)Dataset to merge 2 (2020) Desired output (2019, 2020) As you can see: * Some lines contained in Dataset 2 do not exist in Dataset 1* For example: 107 Company Z * All categories and sub-categories are contained in the same column. Thank you in advance! :) Dataset merge-v1.yxmd

Merge 2 datasets with different structure

Hi, I am trying to merge 2 datasets with the same categories, but different sub-categories into one with all sub-categories.

Here I attach sanitized examples of the datasets I would like to merge, and the desired output:

Dataset to merge 1 (2019)	Dataset to merge 2 (2020)

Desired output (2019, 2020)

As you can see:

Some lines contained in Dataset 2 do not exist in Dataset 1
- For example: 107 Company Z
All categories and sub-categories are contained in the same column.

Thank you in advance!

Workflow

Datasets

Developer

Input

Error Message

Regex

Output

Custom Tools

Join

Hi @selsset97, here is one way of doing this.

Hi @selsset97 , another way of getting your output.

Thank you so much!

Thank you so much!