Method for processing data among systems by using Excel
An excel and data technology, applied in the field of data governance between systems through Excel, can solve problems such as difficult data conversion, achieve efficient data sorting, improve accuracy and work efficiency
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Examples
Embodiment Construction
[0017] Name explanation:
[0018] VSTO: Visual Studio Tools for Office;
[0019] Extraction @Source: data extraction;
[0020] Transformation: data conversion;
[0021] Verify: data verification;
[0022] Loading @Destination: Loading the source system;
[0023] The present invention includes four processes of system data conversion: extracting useful fields from the source data Excel table; converting codes in the data through conversion rules; verifying the converted data; generating new target data. Express the relationship between completed functions and application modules in the following form:
[0024] Define the following basic operations in Excel data governance scenario conversion:
[0025] F=(Swp, Mer, Split, Sort, Rep, Fact, Dist, Check) conversion function is a collection of these types of functions. Among them, Swp is an exchange function, which is a unary operation; Mer is a merge operation, and the entity a i and a j is merged and produces a i+j ;Split...
PUM
Abstract
Description
Claims
Application Information
- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.
© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com