Custom dimension in Table column

[#1]

Hi all,

How can i use the field of different tables as dimension in table.

I need to have the first column of table as,

delivered,

opened,

from EMAILMETRICS table.

`landing_page_hits`,

    `sign_up`,

    completions from CAMPAIGNMETRICS  table.

Header 1	Header 2	Header 3
Delivered
Opened
landing_page_hits
signup
completions

LOAD `campaign_metrics_id`,

    `email_type_id` as metrics_email_type_id,

    sent,

    delivered,

    bounced,

    opened,

    clicks,

    unsubscribes,

    deferred;

SQL SELECT `campaign_metrics_id`,

    `email_type_id`,

    sent,

    delivered,

    bounced,

    opened,

    clicks,

    unsubscribes,

    deferred

FROM EMAILMETRICS;

LOAD `batch_meta_data_id`,

    `landing_page_hits`,

    `sign_up`,

    completions,

    fails,

    partials,

    num_required_subjects;

SQL SELECT

   `batch_meta_data_id`,

    `landing_page_hits`,

    `sign_up`,

    completions,

    fails,

    partials,

    num_required_subjects

FROM CAMPAIGNMETRICS ;

Thanks,

Kumar

[simotrab]

Hi!

Maybe you could try to use the CrossTable function with the Concatenate function.

Here probably something helpful:

The Crosstable Load

The idea is to concatenate two different CrossTable

Here a simple example:

crosstable(header1,header2)

load

dim1,

dim2,

dim3,

dim4,

....

sql select

...

FROM EMAILMETRICS

group by

....;

concatenate

crosstable(header1,header2)

load

dim1,

dim2,

dim3,

dim4,

....

sql select

...

FROM CAMPAIGNMETRICS

group by

....;

[pljsoftware]

Hi Kumar,

you can create a inline table

NewTable:
LOAD * INLINE [
    Header1, Header2, Header3
    delivered, ,
    opened, ,
    landing_page_hits, ,
    sign_up, ,
    completions, ,
];

and if you want to user it in a Pivot table or other chart you can use Set Analysis to get related data.

Best Regards

Luca Jonathan Panetta