Merge two fields as one dimension

[sicdude]

So I have data for a softball team from each of their games.   I would like to see some game by game trending, but each game does not have a unique id.   The ID comes from the Tournament# and the Game# .   Is it possible in the expression editor to use both fields combined as a single dimension?  IE: T1G1, or T2G5?   This isn't a concatenation, but more a "key" scenario

[Vegar · Accepted solution]

You can concatenate  the fields in the script or a calculated dimension into the app.

Script:

Load

[Tournament#] &  [Game#] as ID,

[Tounament#],

[Game#]

From source;

Calculated Dimension

= [Tournament #] & [Game#]