Kapalı

Data Model: Create new columns based on comparison of free text field to lists of values.

In the attached Data Model:

Sheet 1, “Harvest”, consists of 7,000+ time entries and includes a free-text Notes field. This sheet is updated weekly.

Sheet 2, “Lawyers” contains a list of 800 names in “LastName, FirstName” format

Sheet 3, “IPGs,” contains a list of 49 practice groups in “full name” and “acronym“ columns.

I need a formula to create columns for “Lawyers” and “IPGs” in the Harvest sheet so that I can add these two sheets to my data model

The formula for the IPG column will scan the Notes field against the “acronym” column of the IPG sheet. If it finds a string match in the notes it will enter the “full name” of the respective IPG in the cell.

Similarly, the formula for the Lawyers column will scan the Notes field against the name column of the Lawyers sheet. If it finds a string match in the notes it will enter the name of the respective Lawyer in the cell.

The IPGs and Lawyers sheets would then be added to the data model , and relationships would be established between these sheets and the new fields in the Harvest sheet

Ideally these formulas would be done as data transformations in Power Query, so they would be automatically applied to my data model when the Harvest sheet is updated. If that’s not feasible I am OK with entering them manually in the updated Harvest sheet before it is brought into the data model.

Beceriler: Excel, Data Analytics

Daha fazlasını gör: create browser based mmorpg free, free text field upload script, create data dictionary logical data model rational rose, rails create data model uml, scenario create logical data model, erwin scenario create logical data model, create dynamic form based data worksheet, create new business logo free, create new free website, create new logo free, create new website free, model sheet of home based data entry, excel macro to create new workbook based on value in cells, excel macro to create new sheet based on value in cells, sas create new variable based on other variables, pandas create new column based on multiple condition, create new year card online free, pandas create new column based on condition, create pandas column with new values based on values in other columns, import data from the new accounts payable tab delimited text file

İşveren Hakkında:
( 4 değerlendirme ) Toronto, Canada

Proje NO: #28347829

Bu iş için 18 freelancer ortalamada $128 teklif veriyor

schoudhary1553

Hi, Greetings! ✅checked your project details: Data Model: Create new columns based on comparison of free text field to lists of values. ✅Completed Time: In project deadline We have worked on 600 + Projects. I h Daha Fazla

$220 USD in 4 gün içinde
(374 Değerlendirme)
8.1
Devrits

Hi Hiring manager I am IT professional with 23 years of experience implementing software solutions for clients prior to becoming a freelancer. In my career I have worked in all phases of the software development life Daha Fazla

$250 USD in 5 gün içinde
(61 Değerlendirme)
6.1
(14 Değerlendirme)
4.9
WycOj

Data Model: Create new columns based on comparison of free text field to lists of values. EXPERT IN EXCEL Dear client, I can help you with your project of data entry in excel, VBA, excel macros, VB, building an excel f Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(22 Değerlendirme)
4.3
realtechsl

Hi, I have Expertise in data analysis and data modeling. with over 7 years of experience in advance excel i can do the required as per the description. I have downloaded the file as checked it thoroughly Regards

$30 USD in 7 gün içinde
(7 Değerlendirme)
3.5
mumarsami

I am senior IT professional with over 15 years of experience with databases and data warehouses. As per your project description I have all the required skills and experience. If you hire me I will be able to do all y Daha Fazla

$250 USD in 7 gün içinde
(1 Yorum)
2.6
chnsci

Greetings, I think here you are looking for someone to create new columns based on comparison of free text field to lists of values. I have seen the attached file and understood your project description. I am an ex Daha Fazla

$110 USD in 4 gün içinde
(4 Değerlendirme)
2.3
globalgo

Hi, How are you today? Thank you for posting this project, and I'm very happy to bid your project. I've read carefully your project details. I have rich experiences related with your project.... Daha Fazla

$100 USD in 3 gün içinde
(6 Değerlendirme)
2.2
farzana0

I read your project. It is very simple work. I interest in your work. I want to get the job done. I can complete your project on time and within your budget. I have Experience in Excel, Word . I can type 100 words per Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
syedekhlas

Hello sir, I read your project that I possess the necessary skills and experience. You are seeking and would make a valuable addition to add this model in your company. I have the required background, related concept t Daha Fazla

$140 USD in 7 gün içinde
(0 Değerlendirme)
0.0
shahadath16

Dear sir, Greeting, Old account has been closed new account start work. I'm so interested in your project. Already our team finished many similar projects. Give me chance send sample for you. The work will be absolu Daha Fazla

$140 USD in 7 gün içinde
(0 Değerlendirme)
0.0
AlomdaElmasry

Hi There, Thanks for your posting. I read your posting carefully. I have full experiences in Excel, Data Entry, Data Processing. Data Analytics and Web Scraping. I am here at your service. Feel free to Contact me anyt Daha Fazla

$125 USD in 4 gün içinde
(0 Değerlendirme)
0.0
Dmasyithah95

Handle the staff including manage related to staff which is, handle human resource task as a handle staff card, recorded sick leave of staff. I also manage staff allowance, create every official letter that required fr Daha Fazla

$140 USD in 7 gün içinde
(0 Değerlendirme)
0.0
technonazmul

Hi, I have read your job description and I think I am a perfect fit for your project. I can provide you with the best results in no time. Inbox me to discuss further it. Kind Regards Nazmul

$140 USD in 7 gün içinde
(0 Değerlendirme)
0.0
suvamsarkar0707

Hallo sir, I am Suvam Sarkar, I read that project very carefully. If you want to see who have a best project experience in this field be sure to contact me. And this is my fast project I will give my best to get fast r Daha Fazla

$100 USD in 3 gün içinde
(0 Değerlendirme)
0.0
chetankharpuse

Hello, I have completely understood your post where in excel sheet you want to make some formulas similarly in IPG column & Lawyer columns and also you want relationships between these sheets and the new fields in the Daha Fazla

$40 USD in 2 gün içinde
(0 Değerlendirme)
0.0
ABVConsulting

Hey there! I'd like to express my interest in your project requiring some modifications to your existing Excel worksheet. Thanks for providing clear, detailed instructions on your requirements, as well as providing u Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
richardlenny

Hi sir, May i have more details on the job? I like to know how many hour/weeks/months are you looking to hire and what industry is your business. Nonetheless, i believe my english proficiency and experience will all Daha Fazla

$140 USD in 7 gün içinde
(0 Değerlendirme)
0.0