Use Case

AI Merge data files with Powerdrill

Use Case

AI Merge data files with Powerdrill

Use Case

AI Merge data files with Powerdrill

Use Case

AI Merge data files with Powerdrill

Julian Zhou

May 8, 2024

Julian Zhou

May 8, 2024

Julian Zhou

May 8, 2024

Julian Zhou

May 8, 2024

If you have many data files in snippets like CSV, TSV or Excel files, all of them are same in column and schema definition, and you want to merge them into one, Powerdrill AI can help you complete this in a pretty fast manner.

Go to Powerdrill AI, choose "Advanced Analytics". In this demo, I upload 2 CSV data files into a new dataset. Then I try with the following 2 cases:

  • Merge these 2 files, deduplicate the rows if exists. Powerdrill AI automatically merges the data files into one and removes the duplicated rows.

  • Merge these 2 files, keep the duplicated rows if exists. Powerdrill AI automatically merges the data files into one and keep the duplicated rows.The merged data file can be downloaded directly.

Pretty convenient, right? Try it now with Powerdrill AI.

If you have many data files in snippets like CSV, TSV or Excel files, all of them are same in column and schema definition, and you want to merge them into one, Powerdrill AI can help you complete this in a pretty fast manner.

Go to Powerdrill AI, choose "Advanced Analytics". In this demo, I upload 2 CSV data files into a new dataset. Then I try with the following 2 cases:

  • Merge these 2 files, deduplicate the rows if exists. Powerdrill AI automatically merges the data files into one and removes the duplicated rows.

  • Merge these 2 files, keep the duplicated rows if exists. Powerdrill AI automatically merges the data files into one and keep the duplicated rows.The merged data file can be downloaded directly.

Pretty convenient, right? Try it now with Powerdrill AI.