From 6b377719c10d5ab3343fd5221f99a4a21008e25a Mon Sep 17 00:00:00 2001 From: Sébastien Dailly Date: Thu, 14 Mar 2024 08:26:58 +0100 Subject: Initial commit --- examples/importer.toml | 44 ++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 44 insertions(+) create mode 100644 examples/importer.toml (limited to 'examples/importer.toml') diff --git a/examples/importer.toml b/examples/importer.toml new file mode 100644 index 0000000..4be6618 --- /dev/null +++ b/examples/importer.toml @@ -0,0 +1,44 @@ +version = 1 + +[source] + file = "financial.xlsx" + name = "source" + +[externals.target] + intern_key = ":source.A ^ '-suffix'" + extern_key = ":A ^ '-suffix'" + file = "financial.xlsx" + allow_missing = false + +[externals.a_financial] + intern_key = ":target.A" + extern_key = ":O" # This key is here to generate errors + file = "financial.xlsx" + allow_missing = false + +[sheet] + columns = [ + ":target.A ^ '\\''", # Ensure the quote is escaped before sending to the sql engine + "concat('-', :A, :target.E, :B)", + ":C", + "counter([:C], [:A])", + "sum(:F, [:B, :C, :D], [:B])", + "int(1) = counter([:C], [:A])", + ":E", "match('(..)', :B)", + ":D", + "counter([:D], [:A])", + "year(:N)", + # Apply a function on the year + """:Q + - + # We only keep the years after Y2K + 2000""" + + ] + filters = [ + + "1 = counter( [:B], [:A])", + + ] + sort = [] + uniq = [] -- cgit v1.2.3