The instructions given in this chapter describes how to prepare SQL statements required to import document subtype map data to the database.
Figure 101 Expand and copy grouped data
Figure 102 Removing “Drools” and “Deed/Object”columns
Figure 103 Ungrouping columns
Figure 104 Ungrouped columns
Figure 105 Remove document type columns
Figure 106 Generate Pivot table
Figure 107 Pivot table parameters (step-1)
Figure 108 Pivot table parameters (step-2)
Figure 109 Define Pivot table range
Figure 110 Select Pivot table range
Figure 111 Add Pivot table range
Figure 112 Pivot table parameters (3)
Figure 113 Delete PIVOT sheet
Figure 114 Rename “Sheet1”
Figure 115 Generate new values
Figure 116 New sheet of values
Figure 117 Copy formula
Figure 118 Paste formula
Figure 119 Activate formula elements (1)
Figure 120 Activate formula elements (2)
Figure 121 Activate formula elements (3)
Figure 122 Initiate formula copying
Figure 123 Copy formula (1)
Figure 124 Copy formula (2)
Figure 125 Copy the update button
Figure 126 Delete “Unpivoted”
Figure 127 Rename “Sheet2” (1)
Figure 128 Rename “Sheet2” (2)