Icon

Exercise4

Chapter 6 / Exercise 4
Workflow: Chapter6/Exercise4 Here we have single files, each one containing a data column of a bigger data table.Let's list all the file name, for each filename build the correct path, read the data from the file.At the end all data columns read from files are joined together in the Loop End (Column Append) node. file typesamountproductcountryetc ...build file pathfrom path as global flow varand file type from loop varsjoin read filesas if they were single columns of a bigger tableget file typesone by oneread fileusing flow var filepathNode 26 Table Creator String Manipulation(Variable) Loop End (ColumnAppend) Table Row ToVariable Loop Start CSV Reader String to Path(Variable) Workflow: Chapter6/Exercise4 Here we have single files, each one containing a data column of a bigger data table.Let's list all the file name, for each filename build the correct path, read the data from the file.At the end all data columns read from files are joined together in the Loop End (Column Append) node. file typesamountproductcountryetc ...build file pathfrom path as global flow varand file type from loop varsjoin read filesas if they were single columns of a bigger tableget file typesone by oneread fileusing flow var filepathNode 26 Table Creator String Manipulation(Variable) Loop End (ColumnAppend) Table Row ToVariable Loop Start CSV Reader String to Path(Variable)

Nodes

Extensions

Links