══лл
7H
\ @ 0╓mfd_id
Name
Typemfd_id_xmfd_idName_x
Name *
*
x C@ W{ Оmfd_id
NamePropertyValuemfd_id_xmfd_id Name_Property_x
NameProperty Property_Name_xProperty
Name!
!" "#░
$%@#$ 'B%&шmfd_id
nameA
B
C
D
mfd_id_xmfd_id' &' ,()) *
* LA++
О 0 .01x 23/-@12. ╙34┌mfd_idgroupcategorypercentagemfd_id_xmfd_id5 ,4-5(8,6/6 ╧ 'щ=№▄ў юЇ,Кjы╦#
} 11O
╖]┴╒1EжL╠р<╥Q yi ▄ы
C
╛А╕
(
У
╪
Xl╚к
mfd_roottablemfd_metatable
testtableCommentscommentsQuery query
Tabletable&:ThzОи┬╓ъ■ Comments mfd_meta mfd_rootQuery-2TableTatestng
l;mfd_rootPath.0.ValueSystem Datamfd_root&Path.0.DescriptionHSystem components used by Manifold.mfd_rootFolderSystem Data mfd_meta
FolderSystem DataComments
Text <comments> w Want to me Want to merge &Want to merge T1, *Want to merge T1, 50 <Want to merge T1, 50% of T2, NWant to merge T1, 50% of T2, 25% of T3 PWant to merge T1, 50% of T2, 25% of T3 hWant to merge T1, 50% of T2, 25% of T3 into a group ДWant to merge T1, 50% of T2, 25% of T3 into a group
and merge МWant to merge T1, 50% of T2, 25% of T3 into a group
and merge T4 a ШWant to merge T1, 50% of T2, 25% of T3 into a group
and merge T4 with 50 жWant to merge T1, 50% of T2, 25% of T3 into a group
and merge T4 with 50% of T2 ║Want to merge T1, 50% of T2, 25% of T3 into a group
and merge T4 with 50% of T2, and 75% ┬Want to merge T1, 50% of T2, 25% of T3 into a group
and merge T4 with 50% of T2, and 75% of T ╠Want to merge T1, 50% of T2, 25% of T3 into a group
and merge T4 with 50% of T2, and 75% of T3
ъWant to merge T1, 50% of T2, 25% of T3 into a group
and merge T4 with 50% of T2, and 75% of T3 into a group
Want to merge T1, 50% of T2, 25% of T3 into a group
and merge T4 with 50% of T2, and 75% of T3 into a group
and put T5
Want to merge T1, 50% of T2, 25% of T3 into a group
and merge T4 with 50% of T2, and 75% of T3 into a group
and put T5 into another g
&Want to merge T1, 50% of T2, 25% of T3 into a group
and merge T4 with 50% of T2, and 75% of T3 into a group
and put T5 into another group.
2Want to
merge T1, 50% of T2, 25% of T3 into a group
and merge T4 with 50% of T2, and 75% of T3 into a group
and put T5 into another group.
0Want to
- merge T1, 50% of T2, 25% of T3 into a group
merge T4 with 50% of T2, and 75% of T3 into a group
and put T5 into another group.
Want to
- T1, 50% of T2, 25% of T3 into a group
-ge T4 with 50% of T2, and 75% of T3 into a group
and put T5 into another group.
Want to
- T1, 50% of T2, 25% of T3 into a group
- T4 with 50% of T2, and 75% of T3 into a group
- nd put T5 into another group.
шWant to
- T1, 50% of T2, 25% of T3 into a group
- T4 with 50% of T2, and 75% of T3 into a group
- T5.
ЇWant to group t
- T1, 50% of T2, 25% of T3 into a group
- T4 with 50% of T2, and 75% of T3 into a group
- T5
Want to group table into 3 groups
- T1, 50% of T2, 25% of T3 into a group
- T4 with 50% of T2, and 75% of T3 into a group
- T5
,Want to group table into 3 groups with the
- T1, 50% of T2, 25% of T3 into a group
- T4 with 50% of T2, and 75% of T3 into a group
- T5
<Want to group table by name into 3 groups with the
- T1, 50% of T2, 25% of T3 into a group
- T4 with 50% of T2, and 75% of T3 into a group
- T5
RWant to group table by name into the following 3 groupsth the
- T1, 50% of T2, 25% of T3 into a group
- T4 with 50% of T2, and 75% of T3 into a group
- T5
HWant to group table by name into the following 3 groups:
- T1, 50% of T2, 25% of T3 into a group
- T4 with 50% of T2, and 75% of T3 into a group
- T5
bWant to group table (keeping fielby name into the following 3 groups:
- T1, 50% of T2, 25% of T3 into a group
- T4 with 50% of T2, and 75% of T3 into a group
- T5
pWant to group table (keeping fields A,B,by name into the following 3 groups:
- T1, 50% of T2, 25% of T3 into a group
- T4 with 50% of T2, and 75% of T3 into a group
- T5
zWant to group table (keeping fields A,B,C,D) by name into the following 3 groups:
- T1, 50% of T2, 25% of T3 into a group
- T4 with 50% of T2, and 75% of T3 into a group
- T5
~Want to group table (keeping fields A,B,C,D)
by name into the following 3 groups:
- T1, 50% of T2, 25% of T3 into a group
- T4 with 50% of T2, and 75% of T3 into a group
- T5
LWant to group table
by name into the following 3 groups:
- T1, 50% of T2, 25% of T3 into a group
- T4 with 50% of T2, and 75% of T3 into a group
- T5
zWant to group table by name (keeping fields A,B,C,D) into the following 3 groups:
- T1, 50% of T2, 25% of T3 into a group
- T4 with 50% of T2, and 75% of T3 into a group
- T5
ВWant to group table by name
(keeping fields A,B,C,D)
into the following 3 groups:
- T1, 50% of T2, 25% of T3 into a group
- T4 with 50% of T2, and 75% of T3 into a group
- T5
АWant to group table by name
(keeping fields A,B,C,D)
into the following 3 groups:
- T1, 50% of T2, 25% of T3 into a group
- T4 with 50% of T2, and 75% of T3 into a group
- T5
ОWant to group table by name
(keeping fields A,B,C,D)
into the following 3 groups:
- Group1:T1, 50% of T2, 25% of T3 into a group
- T4 with 50% of T2, and 75% of T3 into a group
- T5
ЬWant to group table by name
(keeping fields A,B,C,D)
into the following 3 groups:
- Group1: T1, 50% of T2, 25% of T3 into a group
- GroupT4 with 50% of T2, and 75% of T3 into a group
- T5
дWant to group table by name
(keeping fields A,B,C,D)
into the following 3 groups:
- Group1: T1, 50% of T2, 25% of T3 into a group
- Group2: T4 with 50% of T2, and 75% of T3 into a group
- T5
╢Want to group table by name
(keeping fields A,B,C,D)
into the following 3 groups:
- Group1: T1, 50% of T2, 25% of T3 into a group
- Group2: T4 with 50% of T2, and 75% of T3 into a group
- Group3: T5
Query
Text V-- $manifold$
SELECT * FROM [mfd_root]; |-- $manifold$
SELECT * FROM [mfd_root];
SELECT
FROM м-- $manifold$
SELECT * FROM [mfd_root];
SELECT
FROM [test]
GROUP BY [name] ║-- $manifold$
SELECT * FROM [mfd_root];
SELECT [name],
FROM [test]
GROUP BY [name] ╞-- $manifold$
SELECT * FROM [mfd_root];
SELECT [name], Sum(C
FROM [test]
GROUP BY [name] ╪-- $manifold$
SELECT * FROM [mfd_root];
SELECT [name], Sum(CASE WHEN
FROM [test]
GROUP BY [name] -- $manifold$
SELECT * FROM [mfd_root];
SELECT [name], Sum(CASE WHEN
FROM [test]
INNER JOIN [Table]
GROUP BY [name] -- $manifold$
SELECT * FROM [mfd_root];
SELECT [name], Sum(CASE WHEN
FROM [test]
INNER JOIN [Table]
ON [test].
GROUP BY [name] 6-- $manifold$
SELECT * FROM [mfd_root];
SELECT [name], Sum(CASE WHEN
FROM [test]
INNER JOIN [Table]
ON [test].[name]=[Table].
GROUP BY [name] J-- $manifold$
SELECT * FROM [mfd_root];
SELECT [name], Sum(CASE WHEN
FROM [test]
INNER JOIN [Table]
ON [test].[name]=[Table].[category]
GROUP BY [name] @-- $manifold$
SELECT * FROM [mfd_root];
SELECT [group], Sum(CASE WHEN
FROM [test]
INNER JOIN [Table]
ON [test].[name]=[Table].[category]
GROUP BY :-- $manifold$
SELECT * FROM [mfd_root];
SELECT [group], Sum(
FROM [test]
INNER JOIN [Table]
ON [test].[name]=[Table].[category]
GROUP BY [group] d-- $manifold$
SELECT * FROM [mfd_root];
SELECT [group], Sum([A]*[percentage]) as
FROM [test]
INNER JOIN [Table]
ON [test].[name]=[Table].[category]
GROUP BY [group] l-- $manifold$
SELECT * FROM [mfd_root];
SELECT [group], Sum([A]*[percentage]) as [A],
FROM [test]
INNER JOIN [Table]
ON [test].[name]=[Table].[category]
GROUP BY [group] -- $manifold$
SELECT * FROM [mfd_root];
SELECT [group], Sum([A]*[percentage]) as [A],
Sum([B]*[percentage]) as [B]
Sum([B]*[percentage]) as [C]
Sum([B]*[percentage]) as [D]
FROM [test]
INNER JOIN [Table]
ON [test].[name]=[Table].[category]
GROUP BY [group] $-- $manifold$
SELECT * FROM [mfd_root];
SELECT [group], Sum([A]*[percentage]) as [A],
Sum([B]*[percentage]) as [B],
Sum([C]*[percentage]) as [C],
Sum([D]*[percentage]) as [D]
FROM [test]
INNER JOIN [Table]
ON [test].[name]=[Table].[category]
GROUP BY [group](-- $manifold$
SELECT * FROM [mfd_root];
SELECT [group],
Sum([A]*[percentage]) as [A],
Sum([B]*[percentage]) as [B],
Sum([C]*[percentage]) as [C],
Sum([D]*[percentage]) as [D]
FROM [test]
INNER JOIN [Table]
ON [test].[name]=[Table].[category]
GROUP BY [group] & H h В ░ 0 P j А а ║ ╕* v, К, ? CommentsText°░№ mfd_metaFolderD mfd_rootFoldert mfd_root Path.0.D mfd_root Path.0.VQueryTextф░¤Foldera mfd_metaFoldert mfd_root Path.0.D mfd_root Path.0.V mfd_rootText CommentsTextQuery░¤