Learn how to merge two objects and return the resulting object using TypeScript functions within the Palantir platform

Question

Learn how to merge two objects and return the resulting object using TypeScript functions within the Palantir platform

I am looking to generate a pivot table by combining data from two objects using TypeScript functions. My plan is to first join the two objects, create a unified object, and then perform groupBy operations along with aggregate functions like sum and min on selected columns. Can anyone guide me on how to achieve this?

Below is the code snippet that I have attempted:

public async test(p1: ObjectSet<objecta>,c1: ObjectSet<objectb>): Promise<ObjectSet<objectc> {
        
        const [results1, results2]= await Promise.all([
            #three dimensional aggregation
            p1
                .groupBy(a1 => a1.year.topValues())
                .segmentBy(a1 => a1.code.byFixedWidth(1))
                .sum(a1=>a1.amt),
            c1
                .groupBy(a1=>a1.yr.topValues())
                .segmentBy(a1 => a1.code.byFixedWidth(1))
                .sum(a1 => a1.FullAmt),
        ]);

        # results3 is three dimensional aggregation how to convert it to object set?
        const results3 = results1.map(itm => ({
            ...results2.find((item) => (item.yr === itm.yr) && item),
            ...itm
        }));
    }

typescript palantir-foundry foundry-functions

Answer 1

Answer №1

It doesn't seem like returning an Object set is officially supported. Have you considered using a custom structure instead?

Maybe returning a custom structure could be a viable solution for your needs.

Below is an example directly from SO, so it might not work exactly as is, but it should give you an idea:

interface IObjectCStructure { 
   foo: string
}

public async test(p1: ObjectSet<objecta>,c1: ObjectSet<objectb>): Promise<Array<IObjectCStructure>> {
    ...

    const results3: Array<IObjectCStructure>> = [];
    
    // It's worth considering whether an n^2 search is necessary
    // Using sets instead of nested loops may improve performance.
    results1.forEach(a => 
        results2.find(b => (a.id === b.id) && a)
                .forEach(item => results.push({
                     foo: item.some_field_you_want
                }));
        
    return results;
}

Answer 2

It doesn't seem like returning an Object set is officially supported. Have you considered using a custom structure instead?

Maybe returning a custom structure could be a viable solution for your needs.

Below is an example directly from SO, so it might not work exactly as is, but it should give you an idea:

interface IObjectCStructure { 
   foo: string
}

public async test(p1: ObjectSet<objecta>,c1: ObjectSet<objectb>): Promise<Array<IObjectCStructure>> {
    ...

    const results3: Array<IObjectCStructure>> = [];
    
    // It's worth considering whether an n^2 search is necessary
    // Using sets instead of nested loops may improve performance.
    results1.forEach(a => 
        results2.find(b => (a.id === b.id) && a)
                .forEach(item => results.push({
                     foo: item.some_field_you_want
                }));
        
    return results;
}

Learn how to merge two objects and return the resulting object using TypeScript functions within the Palantir platform

Answer №1

Similar questions

Guide on positioning a span element to the left using the margin auto property in CSS for Angular 4

Methods for transforming a TypeScript class instance containing getter/setter properties into a JSON format for storage within a MySQL database

Ways to extract values from a javascript hash map by exclusively incorporating an array

Updating object properties in Typescript

The attribute 'getValue' is not a valid property for the data type 'Subject<boolean>'

The logic behind regular expressions

When receiving JSON and attempting to store the data in a variable, I encounter an issue where it returns the error message "undefined is not iterable (cannot read property Symbol

What is the best way to relocate the styles folder to the src folder while using nextjs, typescript, and tailwind

Need help with creating a unit test for the Material UI slider component? An error message saying "Error: Cannot read property 'addEventListener' of null" is displayed when trying to render the component

I'm encountering difficulties utilizing ternary operators in TypeScript

Error encountered with default theme styling in Material-UI React TypeScript components

Invoke a function and assign it to an export variable

Strange behavior detected in TypeScript generic function when using a class as the generic parameter

Why isn't my Enum functioning properly to display the colored background?

Manipulating arrays of objects using JavaScript

The Angular directive ng-if does not function properly when trying to evaluate if array[0] is equal to the string value 'Value'

Visual Studio Code unable to locate source maps for typescript debugging

Typescript displays an error message when attempting to assign a list of string variants to a defined type

Having trouble generating a basic TypeScript definition file

Secure higher order React component above class components and stateless functional components