Union / Vlookup
Merge large data sets with ease. Downloadable CSV generated by performing an Union/vlookup operation with either Inner or Outer Join option on multiple uploaded data sets in Multiple Text File formats
Understanding Union / Vlookup
Easily combine multiple datasets using your chosen ‘Row’ and ‘Column’ headers.
You can pick between Inner or Outer Joins depending on what you need. This free tool lets you work with 2 to 8 columns of data. If you need more flexibility, you can upgrade to one of our Data Management packages.
Union / Vlookup Pricing
Only add the modules you need with one affordable monthly price. Easily pause or cancel at any time.
Union/vlookup
$ 88.00/month
+ $ 10.00 Setup fee
Features
- Supports Union of Multiple DataSets
- Supports Multiple Text File Formats
- Inner/Outer Join
- Ability to designate 'Row Header' column
- Export to standard CSV
See all of the SAYS Platforms great features
Discover SAYS PlatformTry before you buy.
Register for a free account today and you can try out the following reports and tools free of charge.
Ex-Post Return & Risk Data Report
Demo
Ex-Post Return & Risk PDF/Excel Report
Demo
Composite Analysis Data Report
Demo
Composite Analysis PDF/Excel Report
Demo
Union/vlookup
Data Management
Remove Duplicates/Unique List
Data Management
Ex-Post Return & Risk PDF Report
Analysis
IRR Calculation Engine with PE Analysis
Analysis
Return Correlation Matrix
Analysis
Annualization Return Calculator
Analysis
Explore More SAYS Platform Modules
As part of the SAYS Platform Union / Vlookup can add the following advantages to your systems for one simple monthly fee.
Composite Construction
Composite Construction & Management streamlines composite creation, membership, and reporting to meet GIPS® standards with speed...
Composite Reporting
Composite Management & Reporting (CMR) is a modular platform that streamlines composite construction, reporting, and GIPS®...
Performance / Attribution Analysis
Transaction-based performance. Accurate performance calculations using TWR at all levels of a portfolio at any time...
Performance Analysis / Return Generation
Portfolio level performance using market values and inflows/outflows may be calculated within the SAYS platform using,...
Ex-Post Return / Risk Analytics
SAYS offers robust ex-post return and risk analytics for any frequency of portfolio and benchmark time...
NAV Return Analysis
Generate NAV returns across multiple periods and fund types
Blended Benchmark Generation
Benchmark Management lets users quickly build custom and blended benchmarks with flexible rebalancing, using any weighting...
Carve-out Allocation
Carve-out performance generator for GIPS 2020 compliance
Data Management / Normalization
Powerful cloud-based data management tool with data anonymization capability.
Drilldown / Rollup Analysis
Customize and generate Group-level rollup analysis reports
Equity Market Data Subscription
Flexible data downloads available through custom file and web service formats.
Net Transaction Cost
Net of Estimated Transaction Cost Calculator for GIPS 2020 compliance
Remove Duplicate / Unique List
Downloadable CSV Text File generated by performing a Remove Duplicates/Unique List operation on multiple uploaded data...
Return Correlation Matrix
Generate a Return Correlation Matrix from return streams
Union / Vlookup
Merge large data sets with ease. Downloadable CSV generated by performing an Union/vlookup operation with either...
