Parse Data
C:\Users\pasccout\Downloads\challenge_95\apple.ndjson
28591
\n
False
100000
False
False
DoubleQuotes
1
Read the ndjson as CSV
apple.ndjson
Field_1
Parse the JSON line by line
RecordID
1
Int32
6
0
Add a Record ID
Contains([JSON_Name], "drawing")
Custom
=
True
fixed
2018-12-20 13:22:40
0
2018-12-20 13:22:40
2018-12-20 13:22:40
Get the drawing lines
Contains([JSON_Name], "drawing")
JSON_Name
Last
JSON_Name
Split the drawing name
Link the X to the Y per point
Auto format the fields
,
Cross tab the definition fields of each record
Int
Create the points
Reverse the Y for the Heat Map
Produce Report
Error
C:\Users\pasccout\AppData\Local\Temp\1\Engine_14120_5dcbce63267e4e9f9e7bf9fad3d043bf_\Engine_7036_7d288ccdd5f44607ba3058c1efdc08f9_.yxdb
Single
Report
PerRecord
V
Continuous
100%
0
Vertical Layout
Each Individual Record
Apple Drawings Used for the He...
C:\Users\pasccout\Downloads\challenge_95\challenge_95_result.pdf
Layout
Continuous
1
squeeze
warning
Build Apple Drawing
SequencePolyline
Build the Apple
Get the coordinates for each apple
Get the position by row and column
RecordID
Y to Add
Double
8
Empty
If [Row-1:Row Number] = [Row Number] Then
[Row-1:Y to Add]
Else
[Row-1:Y to Add] + (([Min_BR_Bottom] - 0.000010) * 1000000)
EndIf
Determine Y position to add versus original apple
If [Row-1:Row Number] = [Row Number] Then
[Row-1:Y to Add]
E...
RecordID
Row Number
Int32
4
Empty
If Mod([RecordID] - 1, 27) = 0 Then
[Row-1:Row Number] + 1
Else
[Row-1:Row Number]
EndIf
Create a row number (groups of 20)
If Mod([RecordID] - 1, 27) = 0 Then
[Row-1:Row Number] + 1
E...
RecordID
X to Add
Double
8
Empty
If [Row-1:Row Number] = [Row Number] Then
[Row-1:X to Add] + ([Row-1:BR_Right] * 1000000)
Else
0
EndIf
Determine the X position to add based on the prior row
If [Row-1:Row Number] = [Row Number] Then
[Row-1:X to Add] +...
Move the X * Y to display
Int
Create the points
SequencePolyline
Build the Apples in the correct place
[RecordID] <= 1000
Custom
<=
RecordID
True
fixed
2018-12-20 14:48:46
0
20
2018-12-20 14:48:46
2018-12-20 14:48:46
[RecordID] <= 1000
SortID
1
Int32
6
0
Put a sort ID for the join
SortID - Ascending
Get the most bottom position of the apples on the row
Combine all the apples into 1 map
C:\Users\pasccout\AppData\Local\Temp\1\Engine_14120_5dcbce63267e4e9f9e7bf9fad3d043bf_\Engine_7036_7d25e6a7c5e5493e8a1f15f6987139a4_.xml
8
6
5
#fdfeff
False
Miles
10
0.5
IncomingConnection
#1
Base Layers - Points
Placeholder
Base Layers - Lines
Placeholder
Base Layers - Polygons
Placeholder
C:\Users\pasccout\AppData\Local\Temp\1\Engine_14120_5dcbce63267e4e9f9e7bf9fad3d043bf_\Engine_7036_2b22f0269f614cfd8e3f15ed45938fa2_.yxdb
Single
Report
C:\Users\pasccout\AppData\Local\Temp\1\Engine_14120_5dcbce63267e4e9f9e7bf9fad3d043bf_\Engine_7036_9e86feb835c3432a8c66e9ea7ae118d2_.yxdb
Single
Map
Create Heat Map
0
1
Auto
50
Apple Drawing Heat View
Y-coordinate
X-Coordinate
my.topo.colors
100
False
False
Density
True
5.50
5.50
False
5.50
5.50
3x
Create the Heat Map (Plot)
Horizontal
challenge_95_my_solution