The hardware and bandwidth for this mirror is donated by METANET, the Webhosting and Full Service-Cloud Provider.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]metanet.ch.

twbparser

Parse Tableau TWB/TWBX files in R: extract datasources, joins, relationships, fields, and calculated fields, plus inspect and unpack TWBX assets. Built for large workbooks and Shiny integration.

Features

• TWB/TWBX: open packaged workbooks and auto‑extract the largest .twb
• Relationships & joins: parse legacy joins and modern (2020.2+) relationships
• Calculated fields / parameters: list formulas, datatypes, roles, and parameter metadata
• Datasources: connection classes/targets, inferred locations, field counts
• Dependency graph: build/plot field dependency DAGs
• TWBX assets: list/extract images, extracts, text files, etc.

Installation

# Install from GitHub (using pak)
install.packages("pak")
pak::pak("PrigasG/twbparser")

# Or using devtools
install.packages("devtools")
devtools::install_github("PrigasG/twbparser")

Quick Start

Parse a “.twb” file

library(twbparser)

# Parse workbook
parser <- TWBParser$new("path/to/workbook.twb")

# Extract calculated fields
calc_fields <- parser$get_calculated_fields()

# View dependencies
deps <- parser$get_field_dependencies()

# Generate DAG
dag <- parser$generate_dag()

Parse a “.twbx” file

parser <- TWBParser$new("path/to/workbook.twbx")

# Inspect manifest
parser$twbx_manifest

# Extract data sources
sources <- parser$get_datasource_details()

And graph objects (via igraph or ggraph) for visualization:

Rscript -e "twbparser::parse_twb('my_dashboard.twb', output_dir = 'results/')"

Integration Examples

• R Shiny: Build an interactive dashboard showing calculations, filters, and DAG visualizations.
• Power BI: Export calculated field logic to replicate measures in DAX.
• Data lineage: Combine with DiagrammeR or visNetwork for workflow diagrams.

What’s new (0.2.0)

• Custom SQL extraction: twb_custom_sql()
• Initial SQL extraction: twb_initial_sql()
• Published datasource detection: twb_published_refs()
• Pretty formulas: tableau_formula_pretty(), prettify_calculated_fields()
• Optional Server/Cloud helpers: tbs_publish_info(), tbs_custom_sql_graphql()

Contributing

1. Fork the repo
2. Create a feature branch (git checkout -b feature/new-feature)
3. Commit changes (git commit -m ‘Add new feature’)
4. Push branch (git push origin feature/new-feature)
5. Open a Pull Request

License

This package is licensed under the MIT License — see the LICENSE file for details.

These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.