I have about 11 thousand SHP files with unique names and a XLS list with ID that contains in ID field of SHP. How can i select this SHP files that is in XLS list and write them into another folder?
Page 1 / 1
Assuming that the ID field is an attribute in your Shape files and all you have in your Excel file is a list of those IDs. I think the quickest way to do this would be:
1. use the DBF reader (rather then the Shape reader) to build an index of ID & directory/file name, as a CSV file or SQLite table.
2. use the Excel reader to look-up the directory/file name and then use the File Copy writer to move your shape files to your target folder.
I'm suggesting the DBF reader instead of the Shape reader since you don't need to read the shape geometries to lookup the ID.
Where can i get file copy writer? Is this a transformer or its stand alone module?
Where can i get file copy writer? Is this a transformer or its stand alone module?
You also can click in the Canvas and enter File Copy.
Or click in the Canvas and enter FeatureWriter and define File Copy in its parameters.
Oh i understand. But what tool do I use to compare the values from the excel and the ID field.
Oh i understand. But what tool do I use to compare the values from the excel and the ID field.
Thanks. its work good.