This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
vba:tutorials:importwithstage [06.06.2019 09:04:00] yaslaw [Migrieren der Deals nach TBL_DEALS] |
vba:tutorials:importwithstage [18.06.2020 09:31:27] (current) yaslaw [Import] |
||
---|---|---|---|
Line 60: | Line 60: | ||
Nun habe ich das folgende in meiner Tabelle STG_DEALS | Nun habe ich das folgende in meiner Tabelle STG_DEALS | ||
- | <code text STG_DEALS>id | user | deal_date | amount | + | <code text STG_DEALS>id | user | deal_date | amount | user_id |
- | ---|--------|-----------|------------------- | + | ---|--------|-----------|--------------------|--------- |
- | 3 | Hans | 20170207 | EUR 10.500,00- | + | 3 | Hans | 20170207 | EUR 10.500,00- | |
- | 4 | Peter | 20170208 | USD 5.454,00 | + | 4 | Peter | 20170208 | USD 5.454,00 | |
- | 5 | Sandra | 20170216 | EUR 16.546.345,35-</code> | + | 5 | Sandra | 20170216 | EUR 16.546.345,35- | </code> |
===== Normalisieren der User ===== | ===== Normalisieren der User ===== |