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

242

Last 30 days

13302nd

242

Last 90 days

242

Last year

CRAN Check Status

10 NOTE

4 OK

Show all 14 flavors

Flavor	Status	Time
r-devel-linux-x86_64-debian-clang	NOTE	59.8s
r-devel-linux-x86_64-debian-gcc	NOTE	41s
r-devel-linux-x86_64-fedora-clang	NOTE	87.8s
r-devel-linux-x86_64-fedora-gcc	NOTE	97.4s
r-devel-macos-arm64	NOTE	20s
r-devel-windows-x86_64	NOTE	85s
r-oldrel-macos-arm64	OK
r-oldrel-macos-x86_64	OK	60s
r-oldrel-windows-x86_64	OK	97s
r-patched-linux-x86_64	NOTE	52.3s
r-release-linux-x86_64	NOTE	50.6s
r-release-macos-arm64	NOTE
r-release-macos-x86_64	OK	84s
r-release-windows-x86_64	NOTE	82s

Check details (14 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'

OK r-oldrel-macos-arm64

OK r-oldrel-macos-x86_64

OK r-oldrel-windows-x86_64

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’

OK r-release-macos-x86_64

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 9, 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’ ‘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’ ‘rem

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’ ‘rem

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’ ‘rem

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’ ‘rem

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’ ‘rem

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' 'rem

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’ ‘rem

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’ ‘rem

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’ ‘rem

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' 'rem

Dependency Network

Version History

new 2.1.2 Mar 9, 2026

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

Mar 9, 2026

RSS Feed

CRAN Checks

View on CRAN →