README.md

Some redacted/anonymised/simplified example CSVs from real-world projects I've worked on, along with as-trivial-as-possible example usage via XSLT.

This initial version is incomplete and very hurried, I'll finish and polish to whatever degree is useful later

dashboard-example.csv

dashboard-example.xsl

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
  xmlns:xs="http://www.w3.org/2001/XMLSchema"
  exclude-result-prefixes="xs"
  version="4.0">
  
  <xsl:variable name="stt" select="doc('stt.xml')"/> <!-- generated by stt-example.xsl -->
  <xsl:variable name="headers" select="map { 'id': 1, 'status': 7, 'department': 13  }"/>
  
  <xsl:template name="xsl:initial-template">
    <contacts>
      <xsl:for-each select="fn:parse-csv(fn:unparsed-text('dashboard-example.csv'), map { 'headers': false() })">
        <contact id=".($headers?id)">
          <department ref="$stt//level[name = .($headers?department)]/@id"/>
          <status><xsl:value-of select=".($headers?status)"/></status>
        </contact>
      </xsl:for-each>
    </contacts>
  </xsl:template>
</xsl:stylesheet>

stt-example.csv

stt-example.xsl

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
  xmlns:xs="http://www.w3.org/2001/XMLSchema"
  xmlns:f="http://example.org/f"
  exclude-result-prefixes="xs"
  version="4.0">
  
  <xsl:template name="xsl:initial-template">
    <stt>
      <xsl:call-template name="level">
        <xsl:with-param name="rows" select="fn:parse-csv(fn:unparsed-text('stt-example.csv'), map { headers: true() })?body"/>
        <xsl:with-param name="level" select="1"/>
      </xsl:call-template>

    </stt>
  </xsl:template>
  
  <xsl:template name="level">
    <xsl:param name="rows" as="array(*)*"/>
    <xsl:param name="level" as="xs:integer"/>
    <xsl:variable name="next-level" select="$level + 1"/>
    <xsl:variable name="selector" select="f:selector($level)"/>
    <xsl:for-each-group select="$rows" group-by="$selector(.)">
      <xsl:for-each select="current-group()">
        <level id="generate-id()" name="current-group()[1]($level)">
          <xsl:if test="$next-level < 5">
            <xsl:call-template name="level">
              <xsl:with-param name="rows" select="tail(current-group())"/>
              <xsl:with-param name="level" select="$next-level"/>
            </xsl:call-template>
          </xsl:if>
        </level>        
      </xsl:for-each>
    </xsl:for-each-group>
  </xsl:template>
  
  <xsl:function name="f:selector" as="function(array(xs:string*)) as xs:string">
    <xsl:param name="column" as="xs:integer"/>
    
    <xsl:sequence select="function(row as array(xs:string*)) { return $row($column) }"/>
  </xsl:function>
</xsl:stylesheet>

umsatz-1234________1234-20211202.CSV

"Umsatz get�tigt von";"Belegdatum";"Buchungsdatum";"Originalbetrag";"Originalw�hrung";"Umrechnungskurs";"Buchungsbetrag";"Buchungsw�hrung";"Transaktionsbeschreibung";"Transaktionsbeschreibung Zusatz";"Buchungsreferenz";"Geb�hrenschl�ssel";"L�nderkennzeichen";"BAR-Entgelt+Buchungsreferenz";"AEE+Buchungsreferenz";"Abrechnungskennzeichen"
"1234 **** **** 1234";"25.12.22";"27.12.22";"-8,70";"EUR";"1,00";"-8,70";"EUR";"Ashop";"Amsterdam";"0";"";"";"";"";""
"1234 **** **** 1234";"16.12.22";"19.12.22";"-0,47";"EUR";"1,00";"-0,47";"EUR";"2,5% f�r W�hrungsumrechnu";"Bshop";"2";"";"";"";"";""
"1234 **** **** 1234";"16.12.22";"19.12.22";"-20,00";"USD";"1,06";"-18,88";"EUR";"Bshop";"San Francisco";"1";"";"";"";"";""
"1234 **** **** 1234";"14.12.22";"14.12.22";"-31,95";"EUR";"1,00";"-31,95";"EUR";"Cshop";"12345678";"3";"";"";"";"";""
"1234 **** **** 1234";"13.12.22";"13.12.22";"-8,00";"USD";"1,05";"-7,61";"EUR";"Dshop";"San Francisco";"4";"";"";"";"";""
"1234 **** **** 1234";"13.12.22";"13.12.22";"-0,19";"EUR";"1,00";"-0,19";"EUR";"2,5% f�r W�hrungsumrechnu";"Dshop";"5";"";"";"";"";""
"1234 **** **** 1234";"09.12.22";"12.12.22";"-319,00";"EUR";"1,00";"-319,00";"EUR";"Eshop";"Luxembourg";"7";"";"";"";"";""
"1234 **** **** 1234";"11.12.22";"12.12.22";"-173,00";"EUR";"1,00";"-173,00";"EUR";"Fshop";"Prague";"6";"";"";"";"";""
"1234 **** **** 1234";"02.12.22";"05.12.22";"-2,81";"EUR";"1,00";"-2,81";"EUR";"Gshop";"internet";"8";"";"";"";"";""
"1234 **** **** 1234";"01.12.22";"01.12.22";"55,60";"EUR";"1,00";"550,60";"EUR";"Abrechnung";"";"10";"";"";"";"";""

works-example.csv