Icon

20210607 PIKAIROS Lectura ficheros de SHP tomando nombre fichero

Reading multiple files using loops

This workflow demonstrates how to read multiple files using a loop.

This meta node creates a folder inthe temp space and puts a couple of files into it. The flow variableoutput denotes the path to this temporary folder(This meta node is usually not needed- it's only to make this workflow workon any system.)for each fileThis reads thefile from the currentvariable, prefixing rows. Note, the files all needto have the same structure/columns. If they don't you need to do extra work (use CSV Reader then)just concatenates.The "uniquify" optionis disable as we assert uniquerowIDs in the loopthis determines therow prefix in the filereader, e.g.File-x-Row12Usa aqui unChunk Loop Startcon"rows per chunk = 1"This reads thefile from the currentvariable, prefixing rows. Note, the files all needto have the same structure/columns. If they don't you need to do extra work (use CSV Reader then)just concatenates.The "uniquify" optionis disable as we assert uniquerowIDs in the loopTransfiere el nombredel fichero a unavariableAñade aqui la URLa los rows leidosdel fichero actualGuarda unicamentla column que teinteresa :el URL del ficheropor ejemploCreate ExampleFiles in Temp Table Row ToVariable Loop Start File Reader Loop End Java Edit Variable List Files Chunk Loop Start File Reader Loop End Table Rowto Variable Cross Joiner Column Filter This meta node creates a folder inthe temp space and puts a couple of files into it. The flow variableoutput denotes the path to this temporary folder(This meta node is usually not needed- it's only to make this workflow workon any system.)for each fileThis reads thefile from the currentvariable, prefixing rows. Note, the files all needto have the same structure/columns. If they don't you need to do extra work (use CSV Reader then)just concatenates.The "uniquify" optionis disable as we assert uniquerowIDs in the loopthis determines therow prefix in the filereader, e.g.File- x-Row12 Usa aqui unChunk Loop Startcon"rows per chunk = 1"This reads thefile from the currentvariable, prefixing rows. Note, the files all needto have the same structure/columns. If they don't you need to do extra work (use CSV Reader then)just concatenates.The "uniquify" optionis disable as we assert uniquerowIDs in the loopTransfiere el nombredel fichero a unavariableAñade aqui la URLa los rows leidosdel fichero actualGuarda unicamentla column que teinteresa :el URL del ficheropor ejemploCreate ExampleFiles in Temp Table Row ToVariable Loop Start File Reader Loop End Java Edit Variable List Files Chunk Loop Start File Reader Loop End Table Rowto Variable Cross Joiner Column Filter

Nodes

Extensions

Links