Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to add all the dimension in Pivot/Straight table dynamically. For example I have following 2 dimensions(PID and Product) in the load statement:
Load * inline [
PID, Product, Amount
1,Product1,100
2,Product2,200
]
But in later stage I'll add more dimension in the script or I'll use load *. Now In UI, how we will add all the loaded dimension automatically.
Is there any way to do this.(I dont want to add dimension manually bcz in my data, dimension were change frequently )
Please share your comments on it.
Hi Soha,
Apply in following way:
TableX:
Load * inline [
PID, Product, Amount
1,Product1,100
2,Product2,200
];
TableY:
load * ,
'Test1',
'test2'
Resident TableX;
drop Table TableX;
It will add two more dimensions like test1 and test2
Thanks,
I want to add dimension name dynamically in Pivot or Straight Table. I am using Load * from Table name.
Please read my question properly.