1 AT_BANNER([pivot table rendering])
3 AT_SETUP([1-d pivot table])
4 AT_DATA([pivot.txt], [[
5 /col "a"*("a1", "a2", "a3")
7 /title "Columns" /display
8 /title "Rows" /transpose.
10 AT_CHECK([pivot-table-test --table-look $srcdir/output/look.stt pivot.txt --box unicode], [0], [dnl
31 AT_SETUP([2-d pivot table])
32 AT_DATA([pivot.txt], [[
33 /col "a"("a1", "a2", "a3")
34 /col "b"("b1", "b2", "b3")
36 /title "Columns" /display
37 /title "Rows" /transpose /display
38 /title "Column x Row" /move "a" column /display
39 /title "Row x Column" /transpose
41 AT_CHECK([pivot-table-test --table-look $srcdir/output/look.stt pivot.txt --box unicode], [0], [dnl
43 ╭────────┬────────┬────────╮
45 ├──┬──┬──┼──┬──┬──┼──┬──┬──┤
46 │a1│a2│a3│a1│a2│a3│a1│a2│a3│
47 ├──┼──┼──┼──┼──┼──┼──┼──┼──┤
48 │ 0│ 1│ 2│ 3│ 4│ 5│ 6│ 7│ 8│
49 ╰──┴──┴──┴──┴──┴──┴──┴──┴──╯
86 AT_SETUP([2-d pivot table - dimension labels])
87 AT_DATA([pivot.txt], [[
88 /col "a"*("a1", "a2", "a3")
89 /col "b"*("b1", "b2", "b3")
91 /title "Columns" /display
92 /title "Rows - Corner" /transpose /display
93 /title "Rows - Nested" /look rowlabels=nested /display
94 /title "Column x Row - Corner" /move "a" column /look rowlabels=corner /display
95 /title "Column x Row - Nested" /look rowlabels=nested /display
96 /title "Row x Column - Corner" /transpose /look rowlabels=corner /display
97 /title "Row x Column - Nested" /look rowlabels=nested
99 AT_CHECK([pivot-table-test --table-look $srcdir/output/look.stt pivot.txt --box unicode], [0], [dnl
101 ╭──────────────────────────╮
103 ├────────┬────────┬────────┤
105 ├────────┼────────┼────────┤
107 ├──┬──┬──┼──┬──┬──┼──┬──┬──┤
108 │a1│a2│a3│a1│a2│a3│a1│a2│a3│
109 ├──┼──┼──┼──┼──┼──┼──┼──┼──┤
110 │ 0│ 1│ 2│ 3│ 4│ 5│ 6│ 7│ 8│
111 ╰──┴──┴──┴──┴──┴──┴──┴──┴──╯
145 Column x Row - Corner
156 Column x Row - Nested
167 Row x Column - Corner
178 Row x Column - Nested
191 AT_SETUP([2-d pivot table - groups])
192 AT_DATA([pivot.txt], [[
193 /col "a"("a1", "ag1"("a2", "a3"))
194 /col "b"("bg1"("b1", "b2"), "b3")
196 /title "Columns" /display
197 /title "Rows" /transpose /display
198 /title "Column x Row" /move "a" column /display
199 /title "Row x Column" /transpose /display
200 /title "Row x Column - delete b2" /cells[all,1]=delete /display
201 /title "Row x Column - delete b2 - show empty" /look empty=show /display
202 /title "Row x Column - delete b1" /cells[all,0]=delete /look empty=hide /display
203 /title "Row x Column - delete b1 - show empty" /look empty=show.
205 AT_CHECK([pivot-table-test --table-look $srcdir/output/look.stt pivot.txt --box unicode], [0], [dnl
207 ╭─────────────────┬────────╮
209 ├────────┬────────┤ │
211 ├──┬─────┼──┬─────┼──┬─────┤
212 │ │ ag1 │ │ ag1 │ │ ag1 │
213 │ ├──┬──┤ ├──┬──┤ ├──┬──┤
214 │a1│a2│a3│a1│a2│a3│a1│a2│a3│
215 ├──┼──┼──┼──┼──┼──┼──┼──┼──┤
216 │ 0│ 1│ 2│ 3│ 4│ 5│ 6│ 7│ 8│
217 ╰──┴──┴──┴──┴──┴──┴──┴──┴──╯
261 Row x Column - delete b2
273 Row x Column - delete b2 - show empty
285 Row x Column - delete b1
295 Row x Column - delete b1 - show empty
309 AT_SETUP([2-d pivot table - layers])
310 AT_DATA([pivot.txt], [[
311 /col "a"("a1", "a2", "a3")
312 /layer "b"("b1", "b2", "b3")
314 /title "Column x b1" /display
315 /title "Row x b1" /transpose /display
316 /title "Column x b2" /show layer 1 /transpose /display
317 /title "Row x b2" /transpose /display
318 /title "Column (All Layers)" /look layers=all /display
319 /title "Row (All Layers)" /transpose /look layers=all
321 AT_CHECK([pivot-table-test --table-look $srcdir/output/look.stt pivot.txt --box unicode], [0], [dnl