We
have a aggregated view which runs on a table which is HASH, Range Partitioned
on two columnsCase
1: SELECT
"Thing" AS THING_ID,
"PropertyValue",
"PropertySetTypeId",
"PropertyId"FROM
"READINGS_CURRENT" AS RCwhereRC."PropertySetTypeId" in
('hea...
Hi,Here i would like to show how I used SAP Visual Intelligence to generate statistics and was able to determine where sale would increase in the next quarter.I used a data set of the Clothes that were sold around the Globe, with different type of Cl...
It was an amazing experience in participating the SAP Visual Intelligence DATA GEEK.here are some of my visuals based on population of NEW York CitySo the above graph represents circular stuff with previous year values and expected values of the nex...
Hello,
Is it possible to Transpose Rows to columns, where as the columns might be dynamic.
Ex: Input
Col1 Col2 Col3
1 a 10
1 b 20
1 c 30
2 a 100
2 b 200
2 c 300
And the output:
Col1 a b c
...
Hello,
Is it possible to Transpose Rows to columns, where as the columns might be dynamic.
Ex: Input
Col1 Col2 Col3
1 a 10
1 b 20
1 c 30
2 a 100
2 b 200
2 c 300
And the output:
Col1 a b c
...
Hello,
Is it possible to Transpose Rows to columns, where as the columns might be dynamic.
Ex: Input
Col1 Col2 Col3
1 a 10
1 b 20
1 c 30
2 a 100
2 b 200
2 c 300
And the output:
Col1 a b c
...