Differences

This shows you the differences between two versions of the page.

--- howtos:reading_data_into_arrays [2011/05/17 14:59]
marcus.williams
+++ howtos:reading_data_into_arrays [2011/05/17 15:02]
marcus.williams
@@ Line 2: / Line 2: @@
 There's amost always a mapping required; whether it's done in a TOOL script, a view or in the model.
+Name data informants appropropriately (to indicate their strong data dependence) as opposed to target informats which tend to be more generic. E.g. use "_data" suffix for name, "_d" for index.
+I usually tackle moderately complete imports in a stand alone TOOL script (not a view) kept alongside the source data, which produces a whatIf-friendly output (TOOL or text), along with informants.
 ===== Case 1 - Data informant used in model diagram =====
@@ Line 11: / Line 15: @@
+===== Case 2 - Data informant mapped to target informant in script/view =====
+Write and run script with this format:
+<file>
+Get informants from file
+Export informants
+</file>
+Inspect informants, and create mappings. Grow script to:
+<file>
+Get informants from file
+!Export informants (now optional)
+Define mappings (from parameters or from external file)
+Create/import data with data informants
+Apply mappings
+Export data
+</file>

whatIf? Wiki