Data Tranformation for Tableau

Columns Requiring Data Transformations

---

Master_ID

None required.

---

Tester

None Required

---

LocationID

None required

---

Date

None required

---

Time

None required

---

Provider

None required

---

Operator

None required

---

Network

None required

---

DeviceType

None required

---

NormalLAT

None required

---

NormalLONG

None required

---

cwTr_hops

None required

---

cwStartISP

None required

---

cwStartHops

None required

---

cwStartRTT

None required

---

cwTnISP1

None required

---

cwTnHops1

None required

---

cwTnRTT1

Transform: None required

---

cwTnISP2

Transform: None required Note: The field holds data represented by symbols, mainly * and standard text.

Tableau data type: String

---

cwTnHops2

Transform: (String) Non-numeral text in record rows deleted.

Tableau data type: Number(whole)

---

cwTnRTT2

Transform: (String) Non-numeral text in record rows deleted.

Tableau data type: Number(Decimal)