For many organizations, the thirst for better and faster data to support business decisions cannot be quenched with traditional IT centric data integration tools, Excel, or BI tools which all fall short and lack critical capabilities. A self-service data preparation application that empowers business analysts and data scientists with a visual, interactive experience to find, prep, and publish data... Read More
J.D. Edwards (JDE) stores dates as a 6 digit string, referred to as Julian date format by JDE/Oracle*. See the syntax below for converting this string value to a standard date format in Paxata.
The first digit represents the century ( 0 = 1900’s, 1 = 2000’s, 2 = 2100’s, etc)
The second and third digits represent the year of... Read More
By: Nenshad Bardoliwalla
The exponential growth of data underlying the strategic imperative of enterprise digital transformation has created new business opportunities along with tremendous challenges.
Today, we see organizations of all shapes and sizes embarking on digital transformation. As uncovered in Corinium Digital’s research, the primary drivers of digital transformation are those businesses focused on addressing rising customer expectations and... Read More
Merchant category codes (MCCs) are numbers that classify businesses by what they sell or the service they provide. These four-digit codes are assigned by payment card organizations—Visa, MasterCard, American Express and Discover—when the business first starts accepting these methods of payment.
Use the following steps to perform a lookup with the Merchant Category codes dataset on Paxata:Step 1: Open a Paxata... Read More
Accelerate Time To Business Value from Azure SQL Data Warehouse or HDInsight With Paxata Self-Service Data Preparation
By: Sharmilli Ghosh
Whether you view data as fuel for your digital transformation or whether you call it the oil in the modern economy, the reality is that it’s probably all of that and much more. Actionable insights are locked up in your data – insights that can help deliver better customer experiences, create new products and help optimize your... Read More
Once you build a Paxata Project you may find a few project steps that might be excessive or unnecessary. Muting a step and removing a step work together in this case.
A user can mute a step to make sure no other steps break before deciding to remove the step.MUTING A STEP To mute a Paxata Project step click on... Read More
When dealing with very wide datasets, analysts spend a lot of time searching for a value without knowing which column has that value. In Paxata, there is a pretty simple way for the user to find this value, provided the dataset is not too big!Use the following steps in Paxata to search for a value across columns: Step 1: Start with the... Read More
Converting XML files into rows and columns is automatically handled during import with Paxata. Paxata does a particularly nice job of handling XML, JSON data with regards of converting the xml structure to rows and columns with virtually no additional effort from the end user. The transpose is all handled during import.
Try out these steps to see... Read More
By: Piet Loubser
Through 2018 90% of deployed data lakes will be rendered useless as they’re overwhelmed with information assets captured for uncertain use cases, according to Gartner.1 This is despite growth from pure play Hadoop vendors like Hortonworks and Cloudera. Join our webcast to learn key steps to accelerate value based on our learnings with numerous customers that leverage... Read More
VALUE: Profiling and filtering dates in Paxata can provide a simple and fast method to understand the date/time characteristics of your data (such as trends, outliers, and unexpected values) which may need resolving prior to pushing the data into production. It’s a great way to validate you have been provided an accurate & complete set of data from upstream or third-party... Read More