From 413b86050e364db51eb4f1bb095f70b141c02919 Mon Sep 17 00:00:00 2001 From: Sébastien Dailly Date: Wed, 8 Jan 2025 13:14:40 +0100 Subject: Updated the examples --- examples/importer.toml | 9 ++++----- 1 file changed, 4 insertions(+), 5 deletions(-) (limited to 'examples/importer.toml') diff --git a/examples/importer.toml b/examples/importer.toml index 4be6618..08e9e25 100644 --- a/examples/importer.toml +++ b/examples/importer.toml @@ -1,5 +1,3 @@ -version = 1 - [source] file = "financial.xlsx" name = "source" @@ -19,12 +17,13 @@ version = 1 [sheet] columns = [ ":target.A ^ '\\''", # Ensure the quote is escaped before sending to the sql engine - "concat('-', :A, :target.E, :B)", + "join('-', :A, :target.E, :B)", ":C", "counter([:C], [:A])", "sum(:F, [:B, :C, :D], [:B])", - "int(1) = counter([:C], [:A])", - ":E", "match('(..)', :B)", + "1 = counter([:C], [:A])", + ":E", + "match('(..)', :B)", ":D", "counter([:D], [:A])", "year(:N)", -- cgit v1.2.3