Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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