+51Hi Team,
I have a dynamic CSV file with the following structure:
Day 01102018
Point1
Point2
Point3
Time 01:00
23
40
4
Time 01:30
43
24
21
Time 02:00
130
49
10Is necessary to identify the lines 1-2-3 and in each node (
Time XXXX ) realize the merger with the Points. The Loop process will be
good in this case?
The Image bellow, is my goal:
Attached my example file -
Thanks,
Danilo
+36I would personally read it line by line with a text file reader and then use either variables or adjacent features.
See https://knowledge.safe.com/questions/3346/translating-a-polygon-from-poly-osmosis-polygon-fo.html
Or https://knowledge.safe.com/questions/65092/connect-lines-without-common-id-by-order-in-file.html?childToView=65116#answer-65116
+51I would personally read it line by line with a text file reader and then use either variables or adjacent features.
See https://knowledge.safe.com/questions/3346/translating-a-polygon-from-poly-osmosis-polygon-fo.html
Or https://knowledge.safe.com/questions/65092/connect-lines-without-common-id-by-order-in-file.html?childToView=65116#answer-65116
, First thanks your attention and answer.
I tried to use the transformer AttributeCreator from this Link Attribute Creator but without success.
Could you help me?
Thanks, 15379-textlinebreaks.fmwt
+36, First thanks your attention and answer.
I tried to use the transformer AttributeCreator from this Link Attribute Creator but without success.
Could you help me?
Thanks, 15379-textlinebreaks.fmwt
+36
textlinebreaks.fmwt
+51
textlinebreaks.fmwt
It was perfect.
+15Another (and fun) way to read such a simple structured file would be to realize that you can identify the attributes by using div and mod functions on the txt_line_number.
The first set would then become attribute names and all subsequent sets will be attribute sets.
