1

I'd like to convert my excel to proper format using Google Cloud Dataprep. How do I save my convert flow and use it as a template? For example, if there were two excel files named A and B and I create a flow to merge these two, next time there are two other files named C.xlsx and D.xlsx, how can I use the flow I created to merge C and D?

Lawrence
  • 88
  • 1
  • 1
  • 5

1 Answers1

0

You can copy and reuse recipes (using the right-click or ... context menus and selecting Make a copy > Without inputs), or you can swap the input dataset for the original recipe and select your new file without having to recreate the recipe.

If your goal is automation, this is a bit more difficult when your source is an Excel file (as these are only an allowed format when using the uploader).

If you're able to have the data output in a CSV and uploaded to Cloud Storage, it opens up additional opportunities to schedule and parameterize your process.

justbeez
  • 1,367
  • 7
  • 12