Skip to main content
Question

Find and merge shapefiles(.shp) like YYYY-MM-DD

hoa_le
Contributor
Forum|alt.badge.img+5

Hi,

I have multiple files with structures (File_YYYY-MM-DD). I want to merge all file the same YYYY-MM-DD into one file. Example: File1_2018-07-01; File2_2018-07-01 merge into File_2018-07-01.

And other files make the same.

How to the way to make it? Can be use Stringrepacer function? Thank you

    7 replies

    takashi
    Contributor
    Forum|alt.badge.img+19
    • takashiContributor
    • Contributor
    • August 8, 2018

    I would extract YYYY-MM-DD from the source file name ("fme_feature_type" or "fme_basename") with the StringSearcher, then set the "File_" + <matched result attribute> to the destination feature type name in the writer feature type.

    StringSearcher Parameters Example

    • Search In: @Value(fme_feature_type)
    • Contains Regular Expression: \\d{4}-\\d{2}-\\d{2}
    • Matched Result Attribute: _first_match
    hoa_le
    Contributor
    Forum|alt.badge.img+5
    • hoa_leContributor
    • Author
    • Contributor
    • August 9, 2018
    takashi wrote:

    I would extract YYYY-MM-DD from the source file name ("fme_feature_type" or "fme_basename") with the StringSearcher, then set the "File_" + <matched result attribute> to the destination feature type name in the writer feature type.

    StringSearcher Parameters Example

    • Search In: @Value(fme_feature_type)
    • Contains Regular Expression: \\d{4}-\\d{2}-\\d{2}
    • Matched Result Attribute: _first_match
    Thank you so much. I tried to write .json format, the writer folder can't choose, the dataset have to set filename.json. With the .shp format, it's okie.
    takashi
    Contributor
    Forum|alt.badge.img+19
    • takashiContributor
    • Contributor
    • August 9, 2018
    takashi wrote:

    I would extract YYYY-MM-DD from the source file name ("fme_feature_type" or "fme_basename") with the StringSearcher, then set the "File_" + <matched result attribute> to the destination feature type name in the writer feature type.

    StringSearcher Parameters Example

    • Search In: @Value(fme_feature_type)
    • Contains Regular Expression: \\d{4}-\\d{2}-\\d{2}
    • Matched Result Attribute: _first_match
    There are two types of Fanout - 'Dataset Fanout' and 'Feature Type Fanout'. Which one can be applied depends on whether the destination format is a file-based one or a folder-based one. Since JSON as destination is a file-based format, you can apply 'Dataset Fanout'.

     

    See these links to learn more.

     

    hoa_le
    Contributor
    Forum|alt.badge.img+5
    • hoa_leContributor
    • Author
    • Contributor
    • August 9, 2018
    takashi wrote:
    There are two types of Fanout - 'Dataset Fanout' and 'Feature Type Fanout'. Which one can be applied depends on whether the destination format is a file-based one or a folder-based one. Since JSON as destination is a file-based format, you can apply 'Dataset Fanout'.

     

    See these links to learn more.

     

    Thank you :)

     

    hoa_le
    Contributor
    Forum|alt.badge.img+5
    • hoa_leContributor
    • Author
    • Contributor
    • September 19, 2018

    Hi,

    I have a new question about search filename based on strings.

    For example: A folder point that filename as: point1_2018-07-01, point2_2018-09-02,...

    An other folder polygon that I will use to spatial join with point. The polygons have filename as: poly_2018-07-01, poly_2018-09-02...The point layer and polygon layer have date time the same in file name.

    I want to ask that how to spatial join pair with this point layer with polygon the same date.

    Thank you

    takashi
    Contributor
    Forum|alt.badge.img+19
    • takashiContributor
    • Contributor
    • September 19, 2018
    hoa_le wrote:

    Hi,

    I have a new question about search filename based on strings.

    For example: A folder point that filename as: point1_2018-07-01, point2_2018-09-02,...

    An other folder polygon that I will use to spatial join with point. The polygons have filename as: poly_2018-07-01, poly_2018-09-02...The point layer and polygon layer have date time the same in file name.

    I want to ask that how to spatial join pair with this point layer with polygon the same date.

    Thank you

    Once you have extracted the date part (YYYY-MM-DD) from their file names as an attribute, you can then set it to the Group By parameter of a transformer which you would like to use to perform spatial operations.

     

     

    hoa_le
    Contributor
    Forum|alt.badge.img+5
    • hoa_leContributor
    • Author
    • Contributor
    • September 20, 2018
    takashi wrote:
    Once you have extracted the date part (YYYY-MM-DD) from their file names as an attribute, you can then set it to the Group By parameter of a transformer which you would like to use to perform spatial operations.

     

     

    Thank you, I done it :)

     

     

    Reply


    Most helpful members this week

    Community Stats

    30,851
    Posts
    116,969
    Replies
    38,683
    Members
    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.