Submit your innovative use case or inspiring success story to the 2023 Dataiku Frontrunner Awards! LET'S GO

Stacking two datasets and writing the result into one of the input datasets.

Solved!
shahriyar
Level 2
Stacking two datasets and writing the result into one of the input datasets.

I have a case where I stack two datasets but the output of the stack operation is one of the input datasets. For example,  I have Datasets A and B, I stack them and write the result into A. However, the output is only created by B, in other words, previous rows from dataset A are lost. Is there any solution for that without using any script, with just using stack recipe? I am able to use the same datasets as both input and output in other recipes, but in this case, the stack recipe does not seemingly work in that way.

0 Kudos
1 Solution
AdrienL
Dataiker

Hi,

Instead of a stack recipe, you can use a sync recipe from B to A and set the output on append mode: in the input/output tab of the recipe, on the A output, check "Append instead of overwrite".

View solution in original post

2 Replies
AdrienL
Dataiker

Hi,

Instead of a stack recipe, you can use a sync recipe from B to A and set the output on append mode: in the input/output tab of the recipe, on the A output, check "Append instead of overwrite".

shahriyar
Level 2
Author

@AdrienL Thanks a lot!