diff options
Diffstat (limited to 'examples/importer.toml')
| -rw-r--r-- | examples/importer.toml | 9 |
1 files changed, 4 insertions, 5 deletions
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)", |