I have a text list of Rasters which have to be processed. How do I iterate through each row in the list and use that value as the input for my transformer?
Page 1 / 1
Have a look at the ListExploder.
@robertdbuckley
If you want to iterate trough the list though..
You can create a index and use it a listindex for the listindexer through a custom transformer. Test for index = number of entries in your list on iteration.
Or clone a dummy to the number of listentries and use _copynum as a listindex for the listindexer
@robertdbuckley
If you want to iterate trough the list though..
You can create a index and use it a listindex for the listindexer through a custom transformer. Test for index = number of entries in your list on iteration.
Or clone a dummy to the number of listentries and use _copynum as a listindex for the listindexer
If I understand correctly, you have a path to a raster in Column A of each excel file, and the rows correspond between files. So if you exposed the xlsx_row_id on each reader, the matching values would be the two rasters you need to subtract from one another.
If that's the case, connect both Excel Readers FeatureReaders to read in the rasters, making sure to merge attributes, so that the rasters have the xlsx_row_id, use a RasterExpressionEvaluator in two raster mode, with the Group-By set to the xlsx_row_id.
Ah, ok.
You have the paths in separate sheets. So not an actual "list" as in terminology of fme.
Then you can just read both excels and merge them by excel row number . (you can expose the xlsx_row_id on the excel reader, right click) Read the rasters form clomns A and feed to RasterCellValueCalculator.
Or simply read both excels, feed them to the transformer and set GroupBy to xlxs_row_id.