Icon

PD Flows

KARS

Vantage

Operations

Commercial

Usage Instructions:

Go to the "Variable Creator" node and configure the paths to your OneDrive. (1)

e.g. "C:\Users\HSilva01\Kenvue Brands LLC\OSS Data Analytics & Digital - Documents\General\..."

If the flow is run after C+16, it's needed to change the node "Top k Row Filter" to the "Row Filter" to obtain the file from C+9, that is not the most recent on the folder. (2)

Execute both "Table Row To Variable" in Operations and Commercial and confirm that the files are with the date of C+9. (3)

Determine Auto Month Year

1
2
2
3
3
Expression
List Files/Folders
String to Date&Time (deprecated)
Files/Folders Meta Info
Expression
Rule-based Row Filter
Concatenate
Get the most recent file
Top k Row Filter
Metanode
List Files/Folders
Table Row to Variable
Output File Names
Date&Time Shift (deprecated)
Date&Time Part Extractor
Column Filter
Create Date&Time Range (deprecated)
Only CBRE
Rule-based Row Filter
Expression
Only CBRE
Rule-based Row Filter
Excel Writer
Column Renamer
Column Renamer
Excel Reader
Unpivot
Expression
Table Row to Variable
Rule-based Row Filter
Expression
Cell Splitter
Sorter
Sorter
Column Renamer
Files/Folders Meta Info
Get the most recent file
Top k Row Filter
Table Row to Variable
Ungroup
Column Renamer
Cell Splitter
List Operations Schedule files
List Files/Folders
Excel Reader
Files/Folders Meta Info
ETL
Unpivot
MTR File copy to MTR Used folder
File Copy
Row Filter
Duplicate Row Filter
Excel Writer
MTR File copy to MTR Used folder
File Copy
Top k Row Filter
Row Filter
Table Row to Variable
Column Filter
Duplicate Row Filter
Only Facilities
Rule-based Row Filter
Column Resorter
Row Filter
Excel Reader
List Operations Schedule files
List Files/Folders
Files/Folders Meta Info
Table Row to Variable
Excel Reader
Excel Writer
Excel Writer
Top k Row Filter
Column Resorter
Concatenate
Excel Writer
Column Filter
ETL
String to Path (Variable)
Column Filter
Variable Creator

Nodes

Extensions

Links