Merging data from two tables and present in a single straight table chart

[Anonymous]

Example -

Table 1:

Col1,

Col2,

Col3

Table 2:

Col4,

Col5,

Col6

both tables are not related but column significance is same. In straight table chart how to merge both tables data and show.

am looking for a output like below

col1/col4(col1 & col4 values to be merged and shown in single column)    col2/col5    col3/col6

My requirement does not allow me to do this at the script level and has to be on the presentation layer.

Can anyone help??

[olivierrobin]

hello

what do you want ?

one total line with sum of each column pair

one row per row on input table ? in this case, is there a way to match lines together ?

[shiveshsingh]

Merging means? concatenating the columns in chart?

[cazztfplease]

You could do something like this?

LinkedColumn:

Load Col1 & '/' & Col4 as Col1_Col4,

         Col2 & '/' & Col5 as Col2_Col5,

         Col3 & '/' & Col6 as Col3_Col6

[cazztfplease]

Apologies.  Just saw that you could not do it in script.

[cazztfplease]

You can however use similar logic in the UI.

You can add a calculated dimension and use the script from above.  For example:

= Col1 & '/' Col4

You can then label it as Col1/Col4 or whatever you like in the label prompt box.