To help us to understand the rules more clearly, could you please post another example in a case where there are more than two records?
And clarify how you can convert (56-41N 001-57W) and (56-30N 001-29W) to "52-15.0N 002-30.5E ".
Hi @kat
I simulated your case here:
1) Created the xls file
2) Search by word N - StringSearcher and filter
3) Created a ID_new both output port
4) Joiner by ID_new and group by = NoticeNr
5) Concatenate
Attached the Workspace template FMWT - Workspace_X_Y.fmwt
Thanks,
Danilo
Hi @kat
I simulated your case here:
1) Created the xls file
2) Search by word N - StringSearcher and filter
3) Created a ID_new both output port
4) Joiner by ID_new and group by = NoticeNr
5) Concatenate
Attached the Workspace template FMWT - Workspace_X_Y.fmwt
Thanks,
Danilo
Thanks Danilo. That's great. The only problem I am having with this is that if I have a second NoticeNr with the same issue e.g.
NoticeNr Coordinate ListID
1130 56-41N 1
1130 56-30N 2
1130 001-57W 3
1130 001-29W 4
1134 52-15.0N 002-30.5E
1135 26-41N 1
1135 16-30N 2
1135 46-30N 3
1135 003-57W 4
1135 005-29W 5
1135 008-29W 6
How can I use the counter grouped by NoticeId?
And clarify how you can convert (56-41N 001-57W) and (56-30N 001-29W) to "52-15.0N 002-30.5E ".
Hello takashi, another example:
the original data:
NoticeNr Coordinate ListID
1130 56-41N 1
1130 56-30N 2
1130 001-57W 3
1130 001-29W 4
1134 52-15.0N 002-30.5E
1135 26-41N 1
1135 16-30N 2
1135 46-30N 3
1135 003-57W 4
1135 005-29W 5
1135 008-29W 6
the output data I would like to have:
NoticeNr Coordinate
1130 56-41N 001-57W
1130 56-30N 001-29W
1134 52-15.0N 002-30.5E
1135 26-41N 003-57W
1135 16-30N 005-29W
1135 46-30N 008-29W
Is this clear enough ? Or you would like to have more explanations?
And clarify how you can convert (56-41N 001-57W) and (56-30N 001-29W) to "52-15.0N 002-30.5E ".
The format of this row is different from others. What's this?
1134 52-15.0N 002-30.5E
The format of this row is different from others. What's this?
1134 52-15.0N 002-30.5E
For all the other records the second value is 0. e.g. 1135 26-41.0N 003-57.0W. I will extract the degrees, minutes, seconds later on and in these case the seconds will be 0. We have different data source and therefore different formats.
The format of this row is different from others. What's this?
1134 52-15.0N 002-30.5E
In the original data, why most rows have only have one of latitude or longitude but only the 1134 row has both latitude and longitude?
Do you just ignore such an exceptional row?
In the original data, why most rows have only have one of latitude or longitude but only the 1134 row has both latitude and longitude?
Do you just ignore such an exceptional row?
the majority of notices has lat and long in the same row, but there are some exceptions where the lat and lot are in diff rows.
Hi @kat
Thanks your feedback. I revised the Workspace with the new Reader Structure like you wrote us above.
Attached the Workspace template - Workspace_X_Y_Update.fmwt
Thanks,
Danilo
