If I understand your question correctly, you would like to create a CSV entry for every address in the range specified by each row. A cloner might be a simple way to do that. Some attribute managers can handle populating the fields. I’ve attached a workspace that might help as a sample.

Start:

from_address_num    to_address_num    sequence    street    city    state    zip
1    9    1    baker st.    new york    ny    00000
2    6    2    baker st.    new york    ny    00000
101    109    3    broadway st.    new york    ny    00000

End:

current_address    from_address_num    to_address_num    sequence    street    city    state    zip
1    1    9    1    baker st.    new york    ny    00000
3    1    9    1    baker st.    new york    ny    00000
5    1    9    1    baker st.    new york    ny    00000
7    1    9    1    baker st.    new york    ny    00000
9    1    9    1    baker st.    new york    ny    00000
2    2    6    2    baker st.    new york    ny    00000
4    2    6    2    baker st.    new york    ny    00000
6    2    6    2    baker st.    new york    ny    00000
101    101    109    3    broadway st.    new york    ny    00000
102    101    109    3    broadway st.    new york    ny    00000
103    101    109    3    broadway st.    new york    ny    00000
104    101    109    3    broadway st.    new york    ny    00000
105    101    109    3    broadway st.    new york    ny    00000
106    101    109    3    broadway st.    new york    ny    00000
107    101    109    3    broadway st.    new york    ny    00000
108    101    109    3    broadway st.    new york    ny    00000
109    101    109    3    broadway st.    new york    ny    00000

 

bruttino Thank you so much. It was the best way.

Hi,

bruttino For doing this analysis, I need to do another clone and need your assistance.
I also have 2 fileds: “Street Address Number Suffix From Code” and “Street Address Number Suffix To Code”. For example, from A to D  
Do you have any idea how to handle this field? 
I need to copy based on the number of suffix between From and To, then replace the current suffix.

like A, B, C, and D for this example.

I really appreciate your assistance.

Sorry for the late reply. I didn’t see this until now. To be honest, there is a "CharacterCodeExtractor" in FME that I think should do this, but I wasn't able to get it to work. It's easy to do with a pythoncaller using the ord() and chr() functions though. I attached a sample using python this way.