i have two tables with data. In one table are all the relevant customer information for a revenue calculation, but indeed i need the relevant price information from the other table to lead the calculation.
For one customer it is possible that there are more than 1 price event.
I would like to have my customer data table and with the joined price event columns for each price event if there is one for the customer.
Use the Joiner to join tables based on customer ID and then use the Pivoting node, group on customer, pivot on counter and use “First” aggregation on date and price.
alternatively you can use GroupBy on your second table with group column customer and List aggregation on price. Then use Cell Replacer to add this List column to first table followed with Split Collection Column
I´ve tried it but it doesnt work with my workflow, because i have more than one column from the second price table, that i want to join to the data table.
I dont know but with the cell replacer i have my problems. It is getting stucked and dont join the column.