Cartesian between same field in Alternate State

[sunny_talwar]

Hey Guys -

This is just a hypothetical question, but do we know if a same field in alternate state can behave like Cartesian Product? For example, if I have an inline load like this

Table:

LOAD * Inline [

Dim

1

2

];

and lets call the alternate state as AS. So, can we somehow do this?

Dim_From_Inherited_State               Dim_From_AS_State

1                                                            1

1                                                            2

2                                                            1

2                                                            2

My testing doesn't seem to show that this is possible, but may be someone have ideas here....

What I am trying to do is avoid creating an island table like this

Table:

LOAD * Inline [

Dim2

1

2

];

and somehow make use of alternate state if possible

[marcus_sommer]

Hi Sunny,

I don't believe that you could get these functionality with alternate states but it might be possible to create such cartesian with aggr-functions whereby I'm not sure if this would be easier to handle or have a better performance than using an island table.

What is the aim behind the island table respectively the cartesian? Maybe there are other ways ...

- Marcus

[sunny_talwar]

Trying to help pedro_freire‌ here: Evaluate Chart Expression at line level - Part3 and thought that may be I can somehow use Alternate State.... Do you want to check the discussion and see if you have any ideas