Editing Template:Data to Table/doc (section)

==Examples==

===Lua Table===
A basic DPL query can be converted into a Lua data table:

<pre>
{{Data to Table
|keys=number;;quality;;galaxy
|unquoted=number
|info={{#DPL:
|namespace=
|category=Fish
|uses=Template:Creature Infobox
|include={Creature Infobox}:%PAGE%,{Creature Infobox}:number,{Creature Infobox}:quality,{Creature Infobox}:distribution
|format=,,,
|secseparators=page==,;;number==,,;;quality==,,;;galaxy==,,$$$
}}
}}
</pre>

This produces output in the following format:
{{sh|<nowiki>return {
	['Anchovy'] = {
		['number'] = 074,
		['quality'] = 'Gray',
		['galaxy'] = 'Taffeh',
	},
	['Barred Spinefoot'] = {
		['number'] = 085,
		['quality'] = 'Purple',
		['galaxy'] = 'All Regions',
	},
}</nowiki>|lua}}

===Constant Values===
{{F|value}} can be used when every entry should have the same value:

<pre>
{{Data to Table
|value=day
|info={{#DPL:
|namespace=File
|category=Icons to Invert
|format=,page==%PAGE%$$$,,
}}
}}
</pre>

This produces:
{{sh|<nowiki>return {
	['Crab Icon.png'] = 'day',
	['Crayfish Icon.png'] = 'day',
	['Fish Icon.png'] = 'day',
}</nowiki>|lua}}

If the value should be output as a raw Lua value rather than a string, include {{F|value}} in {{F|unquoted}}.

===Simple JSON Array===
JSON mode can also be used without groups:

<pre>
{{Data to Table
|json=1
|info={{#DPL:
|namespace=File
|category=Icons to Invert
|format=,page==%PAGE%$$$,,
}}
}}
</pre>

This produces:
{{sh|<nowiki>[
	"Crab Icon.png",
	"Crayfish Icon.png",
	"Fish Icon.png"
]</nowiki>|json}}

===Grouped JSON===
Multiple DPL queries can be combined into a single JSON object using groups:

<pre>
{{Data to Table
|json=1

|group1=day
|group1_info={{#DPL:
|namespace=File
|category=Icons to Invert
|format=,page==%PAGE%$$$,,
}}

|group2=night
|group2_info={{#DPL:
|namespace=File
|category=Icons to Invert Night
|format=,page==%PAGE%$$$,,
}}
}}
</pre>

This produces:

{{sh|<nowiki>{
	"day": [
		"Crab Icon.png",
		"Crayfish Icon.png",
		"Fish Icon.png"
	],
	"night": [
		"Special Icon.png"
	]
}</nowiki>|json}}

Groups with no results are automatically omitted. For example, if the night category is empty, the output will simply be:

{{sh|<nowiki>{
	"day": [
		"Crab Icon.png",
		"Crayfish Icon.png",
		"Fish Icon.png"
	]
}</nowiki>|json}}

===Multiple Groups===
Additional groups can be added by continuing the numbering:

<pre>
|group1=day
|group1_info=...

|group2=night
|group2_info=...

|group3=special
|group3_info=...
</pre>

Up to {{F|group10}} / {{F|group10_info}} are supported.