Find insights from millions to billions of rows of data in just seconds. Pivot Billions in the cloud enables analysis of any size data through easy to understand pivot tables and charts. Sign-up for a free account and unleash the power of Pivot Billions on your data today.
Often times, the data you want to analyze might be split over multiple files. In order to analyze all the data as a cohesive data set, you must first combine the files. In Pivot Billions, you can combine data files that have the same schema or data structure by following these steps.
When you have different types of data files that are connected through common keys, Pivot Billions allows you to Join these files in a left join fashion. This is very useful if you want to integrate a lookup table to your primary data set. In the following example, we will combine the two sample New York taxi data files and then join the taxi zone lookup table file located here to the combined data set.
To Join data, follow these steps:
If you need more information or want to inquire about a more custom solution, please send us an email with your inquiry.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.