Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I'm trying to create an individual name in a dimension for every field.
Here is the Example:
Product A Units | Product B Units | Product C Units | Product D Units |
100 | 200 | 300 | 400 |
I'm trying to create a new dimension which would have names of the Product mapped to its units value.
New Dimension
Product A Units A
Product B Units B
Product C Units C
Product D Units D
I did it in the front end using Value list , Pick Match.
But i'm trying to do it in script so it can be simple on front end chart.
Any help is highly appreciated.
Try something like this:
Test:
CrossTable(Dimension, Value)
LOAD RowNo() as Key,
*;
LOAD * Inline
[
Product A Units, Product B Units, Product C Units, Product D Units
100,200,300,400
];
Try something like this:
Test:
CrossTable(Dimension, Value)
LOAD RowNo() as Key,
*;
LOAD * Inline
[
Product A Units, Product B Units, Product C Units, Product D Units
100,200,300,400
];
Maybe use
to transform your table, then you can extract your Unit e.g. using
Subfield(FIELDNAME,' ',2) as Unit
Sunny,
Do we have any field count limitations to use cross table?
field count limitation? Not sure what you mean? can you elaborate?
Stefan,
I'm new to the advanced concepts of data manipulation.
I really do not understand if u just give a keyword.
Anyways thanks.
Like we have 2 field limitation to use Apply map.
I guess you need at least 2 fields for CrossTable to work. Cannot work if you just have 1 field.
Got it.
Thank you Sunny
Sunny,
Is there a chance to rename Dimension and values as other names at a time with Crosstable??
I know we can do it by loading resident in another table.
But just checking