-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathcompanies.wrangle
27 lines (27 loc) · 1.48 KB
/
companies.wrangle
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
settype col: {ZIP Code} type: String
replacepatterns col: {Company Name} with: '' on: `NO USAR` global: true
replacepatterns col: {Company Name} with: '' on: `no usar` global: true
replacepatterns col: {Company Name} with: '' on: `No usar` global: true
replacepatterns col: {Company Name} with: '' on: `NO UTILIZAR` global: true
replacepatterns col: {Company Name} with: '' on: `non usare` global: true
replacepatterns col: {Company Name} with: '' on: `NON USARE` global: true
replacepatterns col: {Company Name} with: '' on: `non utilizzare` global: true
replacepatterns col: {Company Name} with: '' on: `NON UTILIZZARE` global: true
standardize artifactTable: MISSING col: {Company Name}
textformat col: {Company Name} type: trimquotes
textformat col: {Company Name} type: trimwhitespace
rename type: manual mapping: [Country1,'Town']
textformat col: Town type: propercase
textformat col: Town type: removeaccents
textformat col: Town type: removesymbols
standardize artifactTable: MISSING col: Town
deduplicate
rename type: manual mapping: [{Company Name},'company_name']
rename type: manual mapping: [Country,'country']
rename type: manual mapping: [{Company ID 1},'Company_id1']
rename type: manual mapping: [Company_id1,'company_id1']
rename type: manual mapping: [{Company ID 2},'company_id2']
rename type: manual mapping: [{Company ID 3},'company_id3']
rename type: manual mapping: [{Company ID 4},'company_id4']
rename type: manual mapping: [Town,'town']
rename type: manual mapping: [{ZIP Code},'zipcode']