Excel Spreadsheet to track and create joins -

-

i writing lot of sql code @ moment - haven't done in long time , getting frustrated @ time spent working out relationships between tables.

i thinking might idea create in excel list of tables , how join other tables. can use drop down select table1 , table2 , use vlookup or similar find how link , generate join.

i started occurred me may have done in elegant way.

my process far has been create table in excel per table below. can either have dropdown or use filter find appropriate relationship , create code required join:

 table1          |table2       |table1_field    |table_ field    |join type cnsmr           |cnsmr_accnt  |cnsmr_id        |cnsmr_id        |inner cnsmr_accnt     |udefgeneral  |cnsmr_accnt_id  |cnsmr_accnt_id  |inner cnsmr_accnt_tag |cnsmr_accnt  |cnsmr_accnt_id  |cnsmr_accnt_id  |inner wrkgrp          |cnsmr        |wrkgrp_id       |wrkgrp_id       |inner

i can use formula (looking on list of tables table abbreviation:

=" " & a2 & " " & vlookup(a2, 'list of tables'!$a$2:$b$115, 2, false)& " " & e2 & " join " & b2 & " " & vlookup(b2, 'list of tables'!$a$2:$b$115, 2, false) & " on " &vlookup(a2, 'list of tables'!$a$2:$b$115, 2, false) & "." &c2 & " = " & vlookup(b2, 'list of tables'!$a$2:$b$115, 2, false) &"." &d2


Comments

Post a Comment

Popular posts from this blog

How has firefox/gecko HTML+CSS rendering changed in version 38? -

-
i have a little website header no longer renders correctly, since updating firefox 38.0.5 [the faceplant logo missing top right, , main logo no longer centred]. still renders expected in other browsers. how has engine's rendering changed in update? according mdn , list of changes is: css support ruby-position , ruby-align have been added , available default ( bug 1055676 , bug 1123917 , bug 1039006 ). the :unresolved pseudo-class has been implemented custom elements ( bug 1111633 ). the predefined style ethiopic-numeric uses space, instead of dot, suffix match recent change spec ( bug 1120721 ). css transitions on generated content (with ::before , ::after ) on both inline , block splits them start expected specification ( bug 1110277 ). the implementation of css logical properties made big progress. [...] how css transitions start has been modified match recent change of specifications, aiming @ having interoperable behavio
Read more

javascript - Complex json ng-repeat -

-
i try ng-repeat on object, tried several times still stuck. if have idea, , if it's possible share tips kind of situation. [ { "abonnement": { "id": "1", "nom": "bas prix", "tarif": "2.49", "communication": "2h de communication", "vers": "vers fixes et mobiles", "zone": "zone nationale" } }, { "abonnement": { "id": "2", "nom": "national", "tarif": "9.99", "communication": "t\u00e9l\u00e9phonie et sms illimit\u00e9s", "vers": "vers fixes et mobiles", "zone": "zone nationale" } }, { "abonnement": { "id": "3", "nom": "euro", "tarif&
Read more

jquery - Cloning of rows and columns from the old table into the new with colSpan and rowSpan -

-
i using clone jquery. necessary clone gray area in new table. problem cloned rows , columns can has rowspan , colspan. the gray area intersection data-fix-cols , data-fix-rows. my solution not work: <table id="old-table" data-fix-cols='3' data-fix-rows='4'> <tbody> <tr> <td class="gray">clone me</td> <td colspan="2" rowspan="2" class="gray">clone me</td> <td>ashgabat</td> <td>barcelona</td> <td>berlin</td> </tr> <tr> <td rowspan="3" class="gray">clone me</td> <td>bucharest</td> <td>warsaw</td> <td>washington</td> </tr> <tr> <td class="gray">clone me</td>
Read more