Forum Discussion
Combining Multiple Data Tables by Column
Hi!
This seems like it should be simple, but I've spent a couple of hours trying to figure it out 😞
I have a main data table from an API, called Events. Each event has a separate table with price points.
I would like to have one data visualization table that shows a row for each event, and the applicable prices. I've tried transposing, joins, pivots, etc. but nothing is giving me the desired result.
See image below.
Just looking for a point in the right direction, thanks!
Hi,
Append data from Table 2,3 and 4. Merge data from this apended table into Table 1. In the Merged Table, click on any cell in the Level.name column and click on Pivot. Select the function as "Do not aggregate"
4 Replies
Hi,
Share data in a format that can be pasted in an MS Excel file.
Hi,
Append data from Table 2,3 and 4. Merge data from this apended table into Table 1. In the Merged Table, click on any cell in the Level.name column and click on Pivot. Select the function as "Do not aggregate"
