Discover this year's submissions to the Dataiku Frontrunner Awards and give kudos to your favorite use cases and success stories!READ MORE

How to stack partitionned datasets with incoherent partitions?

Jean
Level 1
How to stack partitionned datasets with incoherent partitions?
Hi,

Let's say we have 2 datasets, partitioned by letters :

Dataset 1 :

- partition A

- partition B

Dataset 2 :

- partition B

- partition C



I would like to get a "summed" dataset, where existing partitions are stacked.

Dataset 3 :

- partition A (from 1)

- partition B (from 1 + 2)

- partition C (from 2)



Simply stacking those two datasets fails for partition A and C since one of the sources is empty for each.

Can I do that without scenario variables ?
0 Kudos
1 Reply
Alex_Combessie
Dataiker Alumni
Hi,

You can make it work with a Python recipe and the dataiku API to create necessary partitions on the two datasets (1 and 2). You just need to define empty files for each missing partition. The way you have done it with the "append instead of overwrite" is OK but it is less robust that a Python recipe (that controls for the set of input partitions). Imagine one uses "append", discovers a bug, fixes it, runs the flow again: the output dataset would then contain both the buggy and the correct data.

Cheers,

Alex
0 Kudos

Labels

?
Labels (3)
A banner prompting to get Dataiku