flattabler

Obtaining a Flat Table from Pivot Tables

v2.1.2 · May 1, 2024 · MIT + file LICENSE

Description

Transformations that allow obtaining a flat table from reports in text or Excel format that contain data in the form of pivot tables. They can be defined for a single report and applied to a set of reports.

Downloads

390

Last 30 days

9708th

900

Last 90 days

3.2K

Last year

Trend: +51.2% (30d vs prior 30d)

CRAN Check Status

10 NOTE

4 OK

Show all 14 flavors

Flavor	Status	Time
r-devel-linux-x86_64-debian-clang	NOTE	59.4s
r-devel-linux-x86_64-debian-gcc	NOTE	42.1s
r-devel-linux-x86_64-fedora-clang	NOTE	88.1s
r-devel-linux-x86_64-fedora-gcc	NOTE	96.9s
r-devel-macos-arm64	NOTE	21s
r-devel-windows-x86_64	NOTE	116s
r-oldrel-macos-arm64	OK
r-oldrel-macos-x86_64	OK	60s
r-oldrel-windows-x86_64	OK	101s
r-patched-linux-x86_64	NOTE	54.7s
r-release-linux-x86_64	NOTE	50.5s
r-release-macos-arm64	NOTE
r-release-macos-x86_64	OK	84s
r-release-windows-x86_64	NOTE	82s

Check details (10 non-OK)

NOTE r-devel-linux-x86_64-debian-clang

DESCRIPTION meta-information

Missing dependency on R >= 4.1.0 because package code uses the pipe
  |> or function shorthand \(...) syntax added in R 4.1.0.
  File(s) using such syntax:
    ‘define_labels.Rd’ ‘divide.Rd’ ‘extract_labels.Rd’ ‘fill_labels.Rd’
    ‘fill_values.Rd’ ‘flatten_table_list.Rd’ ‘ft_ex.Rd’ ‘ft_ex_v2.Rd’
    ‘ft_set.Rd’ ‘get_col_values.Rd’ ‘get_page.Rd’ ‘pf_ex_compact.Rd’
    ‘remove_agg.Rd’ ‘remove_bottom.Rd’ ‘remove_cols.Rd’ ‘remove_empty.Rd’
    ‘remove_k.Rd’ ‘remove_left.Rd’ ‘remove_right.Rd’ ‘remove_rows.Rd’
    ‘remove_top.Rd’ ‘replace_dec.Rd’ ‘set_page.Rd’ ‘unpivot.Rd’

NOTE r-devel-linux-x86_64-debian-gcc

DESCRIPTION meta-information

Missing dependency on R >= 4.1.0 because package code uses the pipe
  |> or function shorthand \(...) syntax added in R 4.1.0.
  File(s) using such syntax:
    ‘define_labels.Rd’ ‘divide.Rd’ ‘extract_labels.Rd’ ‘fill_labels.Rd’
    ‘fill_values.Rd’ ‘flatten_table_list.Rd’ ‘ft_ex.Rd’ ‘ft_ex_v2.Rd’
    ‘ft_set.Rd’ ‘get_col_values.Rd’ ‘get_page.Rd’ ‘pf_ex_compact.Rd’
    ‘remove_agg.Rd’ ‘remove_bottom.Rd’ ‘remove_cols.Rd’ ‘remove_empty.Rd’
    ‘remove_k.Rd’ ‘remove_left.Rd’ ‘remove_right.Rd’ ‘remove_rows.Rd’
    ‘remove_top.Rd’ ‘replace_dec.Rd’ ‘set_page.Rd’ ‘unpivot.Rd’

NOTE r-devel-linux-x86_64-fedora-clang

DESCRIPTION meta-information

Missing dependency on R >= 4.1.0 because package code uses the pipe
  |> or function shorthand \(...) syntax added in R 4.1.0.
  File(s) using such syntax:
    ‘define_labels.Rd’ ‘divide.Rd’ ‘extract_labels.Rd’ ‘fill_labels.Rd’
    ‘fill_values.Rd’ ‘flatten_table_list.Rd’ ‘ft_ex.Rd’ ‘ft_ex_v2.Rd’
    ‘ft_set.Rd’ ‘get_col_values.Rd’ ‘get_page.Rd’ ‘pf_ex_compact.Rd’
    ‘remove_agg.Rd’ ‘remove_bottom.Rd’ ‘remove_cols.Rd’ ‘remove_empty.Rd’
    ‘remove_k.Rd’ ‘remove_left.Rd’ ‘remove_right.Rd’ ‘remove_rows.Rd’
    ‘remove_top.Rd’ ‘replace_dec.Rd’ ‘set_page.Rd’ ‘unpivot.Rd’

NOTE r-devel-linux-x86_64-fedora-gcc

DESCRIPTION meta-information

Missing dependency on R >= 4.1.0 because package code uses the pipe
  |> or function shorthand \(...) syntax added in R 4.1.0.
  File(s) using such syntax:
    ‘define_labels.Rd’ ‘divide.Rd’ ‘extract_labels.Rd’ ‘fill_labels.Rd’
    ‘fill_values.Rd’ ‘flatten_table_list.Rd’ ‘ft_ex.Rd’ ‘ft_ex_v2.Rd’
    ‘ft_set.Rd’ ‘get_col_values.Rd’ ‘get_page.Rd’ ‘pf_ex_compact.Rd’
    ‘remove_agg.Rd’ ‘remove_bottom.Rd’ ‘remove_cols.Rd’ ‘remove_empty.Rd’
    ‘remove_k.Rd’ ‘remove_left.Rd’ ‘remove_right.Rd’ ‘remove_rows.Rd’
    ‘remove_top.Rd’ ‘replace_dec.Rd’ ‘set_page.Rd’ ‘unpivot.Rd’

NOTE r-devel-macos-arm64

DESCRIPTION meta-information

Missing dependency on R >= 4.1.0 because package code uses the pipe
  |> or function shorthand \(...) syntax added in R 4.1.0.
  File(s) using such syntax:
    ‘define_labels.Rd’ ‘divide.Rd’ ‘extract_labels.Rd’ ‘fill_labels.Rd’
    ‘fill_values.Rd’ ‘flatten_table_list.Rd’ ‘ft_ex.Rd’ ‘ft_ex_v2.Rd’
    ‘ft_set.Rd’ ‘get_col_values.Rd’ ‘get_page.Rd’ ‘pf_ex_compact.Rd’
    ‘remove_agg.Rd’ ‘remove_bottom.Rd’ ‘remove_cols.Rd’ ‘remove_empty.Rd’
    ‘remove_k.Rd’ ‘remove_left.Rd’ ‘remove_right.Rd’ ‘remove_rows.Rd’
    ‘remove_top.Rd’ ‘replace_dec.Rd’ ‘set_page.Rd’ ‘unpivot.Rd’

NOTE r-devel-windows-x86_64

DESCRIPTION meta-information

Missing dependency on R >= 4.1.0 because package code uses the pipe
  |> or function shorthand \(...) syntax added in R 4.1.0.
  File(s) using such syntax:
    'define_labels.Rd' 'divide.Rd' 'extract_labels.Rd' 'fill_labels.Rd'
    'fill_values.Rd' 'flatten_table_list.Rd' 'ft_ex.Rd' 'ft_ex_v2.Rd'
    'ft_set.Rd' 'get_col_values.Rd' 'get_page.Rd' 'pf_ex_compact.Rd'
    'remove_agg.Rd' 'remove_bottom.Rd' 'remove_cols.Rd' 'remove_empty.Rd'
    'remove_k.Rd' 'remove_left.Rd' 'remove_right.Rd' 'remove_rows.Rd'
    'remove_top.Rd' 'replace_dec.Rd' 'set_page.Rd' 'unpivot.Rd'

NOTE r-patched-linux-x86_64

DESCRIPTION meta-information

Missing dependency on R >= 4.1.0 because package code uses the pipe
  |> or function shorthand \(...) syntax added in R 4.1.0.
  File(s) using such syntax:
    ‘define_labels.Rd’ ‘divide.Rd’ ‘extract_labels.Rd’ ‘fill_labels.Rd’
    ‘fill_values.Rd’ ‘flatten_table_list.Rd’ ‘ft_ex.Rd’ ‘ft_ex_v2.Rd’
    ‘ft_set.Rd’ ‘get_col_values.Rd’ ‘get_page.Rd’ ‘pf_ex_compact.Rd’
    ‘remove_agg.Rd’ ‘remove_bottom.Rd’ ‘remove_cols.Rd’ ‘remove_empty.Rd’
    ‘remove_k.Rd’ ‘remove_left.Rd’ ‘remove_right.Rd’ ‘remove_rows.Rd’
    ‘remove_top.Rd’ ‘replace_dec.Rd’ ‘set_page.Rd’ ‘unpivot.Rd’

NOTE r-release-linux-x86_64

DESCRIPTION meta-information

Missing dependency on R >= 4.1.0 because package code uses the pipe
  |> or function shorthand \(...) syntax added in R 4.1.0.
  File(s) using such syntax:
    ‘define_labels.Rd’ ‘divide.Rd’ ‘extract_labels.Rd’ ‘fill_labels.Rd’
    ‘fill_values.Rd’ ‘flatten_table_list.Rd’ ‘ft_ex.Rd’ ‘ft_ex_v2.Rd’
    ‘ft_set.Rd’ ‘get_col_values.Rd’ ‘get_page.Rd’ ‘pf_ex_compact.Rd’
    ‘remove_agg.Rd’ ‘remove_bottom.Rd’ ‘remove_cols.Rd’ ‘remove_empty.Rd’
    ‘remove_k.Rd’ ‘remove_left.Rd’ ‘remove_right.Rd’ ‘remove_rows.Rd’
    ‘remove_top.Rd’ ‘replace_dec.Rd’ ‘set_page.Rd’ ‘unpivot.Rd’

NOTE r-release-macos-arm64

DESCRIPTION meta-information

Missing dependency on R >= 4.1.0 because package code uses the pipe
  |> or function shorthand \(...) syntax added in R 4.1.0.
  File(s) using such syntax:
    ‘define_labels.Rd’ ‘divide.Rd’ ‘extract_labels.Rd’ ‘fill_labels.Rd’
    ‘fill_values.Rd’ ‘flatten_table_list.Rd’ ‘ft_ex.Rd’ ‘ft_ex_v2.Rd’
    ‘ft_set.Rd’ ‘get_col_values.Rd’ ‘get_page.Rd’ ‘pf_ex_compact.Rd’
    ‘remove_agg.Rd’ ‘remove_bottom.Rd’ ‘remove_cols.Rd’ ‘remove_empty.Rd’
    ‘remove_k.Rd’ ‘remove_left.Rd’ ‘remove_right.Rd’ ‘remove_rows.Rd’
    ‘remove_top.Rd’ ‘replace_dec.Rd’ ‘set_page.Rd’ ‘unpivot.Rd’

NOTE r-release-windows-x86_64

DESCRIPTION meta-information

Missing dependency on R >= 4.1.0 because package code uses the pipe
  |> or function shorthand \(...) syntax added in R 4.1.0.
  File(s) using such syntax:
    'define_labels.Rd' 'divide.Rd' 'extract_labels.Rd' 'fill_labels.Rd'
    'fill_values.Rd' 'flatten_table_list.Rd' 'ft_ex.Rd' 'ft_ex_v2.Rd'
    'ft_set.Rd' 'get_col_values.Rd' 'get_page.Rd' 'pf_ex_compact.Rd'
    'remove_agg.Rd' 'remove_bottom.Rd' 'remove_cols.Rd' 'remove_empty.Rd'
    'remove_k.Rd' 'remove_left.Rd' 'remove_right.Rd' 'remove_rows.Rd'
    'remove_top.Rd' 'replace_dec.Rd' 'set_page.Rd' 'unpivot.Rd'

Check History

NOTE 4 OK · 10 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Mar 10, 2026

NOTE r-devel-linux-x86_64-debian-clang

DESCRIPTION meta-information

Missing dependency on R >= 4.1.0 because package code uses the pipe
  |> or function shorthand \(...) syntax added in R 4.1.0.
  File(s) using such syntax:
    ‘define_labels.Rd’ ‘divide.Rd’ ‘extract_labels.Rd’ ‘fill_labels.Rd’
    ‘fill_values.Rd’ ‘
...[truncated]...
alues.Rd’ ‘get_page.Rd’ ‘pf_ex_compact.Rd’
    ‘remove_agg.Rd’ ‘remove_bottom.Rd’ ‘remove_cols.Rd’ ‘remove_empty.Rd’
    ‘remove_k.Rd’ ‘remove_left.Rd’ ‘remove_right.Rd’ ‘remove_rows.Rd’
    ‘remove_top.Rd’ ‘replace_dec.Rd’ ‘set_page.Rd’ ‘unpivot.Rd’

NOTE r-devel-linux-x86_64-debian-gcc

DESCRIPTION meta-information

Missing dependency on R >= 4.1.0 because package code uses the pipe
  |> or function shorthand \(...) syntax added in R 4.1.0.
  File(s) using such syntax:
    ‘define_labels.Rd’ ‘divide.Rd’ ‘extract_labels.Rd’ ‘fill_labels.Rd’
    ‘fill_values.Rd’ ‘
...[truncated]...
alues.Rd’ ‘get_page.Rd’ ‘pf_ex_compact.Rd’
    ‘remove_agg.Rd’ ‘remove_bottom.Rd’ ‘remove_cols.Rd’ ‘remove_empty.Rd’
    ‘remove_k.Rd’ ‘remove_left.Rd’ ‘remove_right.Rd’ ‘remove_rows.Rd’
    ‘remove_top.Rd’ ‘replace_dec.Rd’ ‘set_page.Rd’ ‘unpivot.Rd’

NOTE r-devel-linux-x86_64-fedora-clang

DESCRIPTION meta-information

Missing dependency on R >= 4.1.0 because package code uses the pipe
  |> or function shorthand \(...) syntax added in R 4.1.0.
  File(s) using such syntax:
    ‘define_labels.Rd’ ‘divide.Rd’ ‘extract_labels.Rd’ ‘fill_labels.Rd’
    ‘fill_values.Rd’ ‘
...[truncated]...
alues.Rd’ ‘get_page.Rd’ ‘pf_ex_compact.Rd’
    ‘remove_agg.Rd’ ‘remove_bottom.Rd’ ‘remove_cols.Rd’ ‘remove_empty.Rd’
    ‘remove_k.Rd’ ‘remove_left.Rd’ ‘remove_right.Rd’ ‘remove_rows.Rd’
    ‘remove_top.Rd’ ‘replace_dec.Rd’ ‘set_page.Rd’ ‘unpivot.Rd’

NOTE r-devel-linux-x86_64-fedora-gcc

DESCRIPTION meta-information

Missing dependency on R >= 4.1.0 because package code uses the pipe
  |> or function shorthand \(...) syntax added in R 4.1.0.
  File(s) using such syntax:
    ‘define_labels.Rd’ ‘divide.Rd’ ‘extract_labels.Rd’ ‘fill_labels.Rd’
    ‘fill_values.Rd’ ‘
...[truncated]...
alues.Rd’ ‘get_page.Rd’ ‘pf_ex_compact.Rd’
    ‘remove_agg.Rd’ ‘remove_bottom.Rd’ ‘remove_cols.Rd’ ‘remove_empty.Rd’
    ‘remove_k.Rd’ ‘remove_left.Rd’ ‘remove_right.Rd’ ‘remove_rows.Rd’
    ‘remove_top.Rd’ ‘replace_dec.Rd’ ‘set_page.Rd’ ‘unpivot.Rd’

NOTE r-devel-macos-arm64

DESCRIPTION meta-information

Missing dependency on R >= 4.1.0 because package code uses the pipe
  |> or function shorthand \(...) syntax added in R 4.1.0.
  File(s) using such syntax:
    ‘define_labels.Rd’ ‘divide.Rd’ ‘extract_labels.Rd’ ‘fill_labels.Rd’
    ‘fill_values.Rd’ ‘
...[truncated]...
alues.Rd’ ‘get_page.Rd’ ‘pf_ex_compact.Rd’
    ‘remove_agg.Rd’ ‘remove_bottom.Rd’ ‘remove_cols.Rd’ ‘remove_empty.Rd’
    ‘remove_k.Rd’ ‘remove_left.Rd’ ‘remove_right.Rd’ ‘remove_rows.Rd’
    ‘remove_top.Rd’ ‘replace_dec.Rd’ ‘set_page.Rd’ ‘unpivot.Rd’

NOTE r-devel-windows-x86_64

DESCRIPTION meta-information

Missing dependency on R >= 4.1.0 because package code uses the pipe
  |> or function shorthand \(...) syntax added in R 4.1.0.
  File(s) using such syntax:
    'define_labels.Rd' 'divide.Rd' 'extract_labels.Rd' 'fill_labels.Rd'
    'fill_values.Rd' '
...[truncated]...
alues.Rd' 'get_page.Rd' 'pf_ex_compact.Rd'
    'remove_agg.Rd' 'remove_bottom.Rd' 'remove_cols.Rd' 'remove_empty.Rd'
    'remove_k.Rd' 'remove_left.Rd' 'remove_right.Rd' 'remove_rows.Rd'
    'remove_top.Rd' 'replace_dec.Rd' 'set_page.Rd' 'unpivot.Rd'

NOTE r-patched-linux-x86_64

DESCRIPTION meta-information

Missing dependency on R >= 4.1.0 because package code uses the pipe
  |> or function shorthand \(...) syntax added in R 4.1.0.
  File(s) using such syntax:
    ‘define_labels.Rd’ ‘divide.Rd’ ‘extract_labels.Rd’ ‘fill_labels.Rd’
    ‘fill_values.Rd’ ‘
...[truncated]...
alues.Rd’ ‘get_page.Rd’ ‘pf_ex_compact.Rd’
    ‘remove_agg.Rd’ ‘remove_bottom.Rd’ ‘remove_cols.Rd’ ‘remove_empty.Rd’
    ‘remove_k.Rd’ ‘remove_left.Rd’ ‘remove_right.Rd’ ‘remove_rows.Rd’
    ‘remove_top.Rd’ ‘replace_dec.Rd’ ‘set_page.Rd’ ‘unpivot.Rd’

NOTE r-release-linux-x86_64

DESCRIPTION meta-information

Missing dependency on R >= 4.1.0 because package code uses the pipe
  |> or function shorthand \(...) syntax added in R 4.1.0.
  File(s) using such syntax:
    ‘define_labels.Rd’ ‘divide.Rd’ ‘extract_labels.Rd’ ‘fill_labels.Rd’
    ‘fill_values.Rd’ ‘
...[truncated]...
alues.Rd’ ‘get_page.Rd’ ‘pf_ex_compact.Rd’
    ‘remove_agg.Rd’ ‘remove_bottom.Rd’ ‘remove_cols.Rd’ ‘remove_empty.Rd’
    ‘remove_k.Rd’ ‘remove_left.Rd’ ‘remove_right.Rd’ ‘remove_rows.Rd’
    ‘remove_top.Rd’ ‘replace_dec.Rd’ ‘set_page.Rd’ ‘unpivot.Rd’

NOTE r-release-macos-arm64

DESCRIPTION meta-information

Missing dependency on R >= 4.1.0 because package code uses the pipe
  |> or function shorthand \(...) syntax added in R 4.1.0.
  File(s) using such syntax:
    ‘define_labels.Rd’ ‘divide.Rd’ ‘extract_labels.Rd’ ‘fill_labels.Rd’
    ‘fill_values.Rd’ ‘
...[truncated]...
alues.Rd’ ‘get_page.Rd’ ‘pf_ex_compact.Rd’
    ‘remove_agg.Rd’ ‘remove_bottom.Rd’ ‘remove_cols.Rd’ ‘remove_empty.Rd’
    ‘remove_k.Rd’ ‘remove_left.Rd’ ‘remove_right.Rd’ ‘remove_rows.Rd’
    ‘remove_top.Rd’ ‘replace_dec.Rd’ ‘set_page.Rd’ ‘unpivot.Rd’

NOTE r-release-windows-x86_64

DESCRIPTION meta-information

Missing dependency on R >= 4.1.0 because package code uses the pipe
  |> or function shorthand \(...) syntax added in R 4.1.0.
  File(s) using such syntax:
    'define_labels.Rd' 'divide.Rd' 'extract_labels.Rd' 'fill_labels.Rd'
    'fill_values.Rd' '
...[truncated]...
alues.Rd' 'get_page.Rd' 'pf_ex_compact.Rd'
    'remove_agg.Rd' 'remove_bottom.Rd' 'remove_cols.Rd' 'remove_empty.Rd'
    'remove_k.Rd' 'remove_left.Rd' 'remove_right.Rd' 'remove_rows.Rd'
    'remove_top.Rd' 'replace_dec.Rd' 'set_page.Rd' 'unpivot.Rd'

Dependency Network

Version History

new 2.1.2 Mar 10, 2026

updated 2.1.2 ← 2.1.1 diff Apr 30, 2024

updated 2.1.1 ← 2.1.0 diff Jan 7, 2024

updated 2.1.0 ← 2.0.0 diff Sep 13, 2023

updated 2.0.0 ← 1.2.0 diff Aug 9, 2023

updated 1.2.0 ← 1.1.0 diff Nov 14, 2020

updated 1.1.0 ← 1.0.0 diff Aug 9, 2020

new 1.0.0 Jun 28, 2020

Maintainer

Jose Samos

Dependencies

Depends

R (>= 2.10)

Imports

dplyr readr readxl stringr tibble

Suggests

knitr pander rmarkdown testthat tidyr

Compilation

No compilation needed

First Published

Jun 28, 2020

RSS Feed

CRAN Checks

View on CRAN →