Import as400 table using excel macro iseries driver jobs
Hello and Thank you for being here Please see below code to read USERS from Keycloak using the api task: - Need to get REALM data for each user - Need to get GROUP data for each user We can do a 2nd Milestone if you like and we can talk about that together ----------------------------------------------------------------------------------------------- WORKING CODE TO READ USERS cat from keycloak import KeycloakAdmin admin = KeycloakAdmin( server_url="serverURL:port", username='admin', password='password', realm_name="master") print("current realm",admin.get_current_realm()) users = admin.get_users({}) if len(users) > 0: print("-------------------------------------") for ...
Hello and Thank you for being here Please see below code to read USERS from Keycloak using the api task: - Need to get REALM data for each user - Need to get GROUP data for each user We can do a 2nd Milestone if you like and we can talk about that together ----------------------------------------------------------------------------------------------- WORKING CODE TO READ USERS cat from keycloak import KeycloakAdmin admin = KeycloakAdmin( server_url="serverURL:port", username='admin', password='password', realm_name="master") print("current realm",admin.get_current_realm()) users = admin.get_users({}) if len(users) > 0: print("-------------------------------------") for u...
Everyday I have to extract some datas from around 100 invoices (PDF files) and copy it to an Excel file. I do it manually (copy/paste), but I need a tool to have it done automatically. These invoices have a consistent format structure, and the fields I need to copy to Excel are always the same. They are informations like: invoice number, date, customer's name, product code, price, etc. All the fields that need to be on Excel are highlighted in color red on the 2 files I'm providing as an example. Any other info not highlighted in red, doesn't need to be on Excel file. The automation process must execute without fail, ensuring that the location of highlighted fields - which are always the same in every file - does not affect the extraction. The o...
I am urgently seeking a proficient macro developer to create a small, efficient macro capable of identifying and removing rows based on specific phrases present in multiple columns. Key Project Requirements: - The developed macro must target multiple columns in the sheet. - Deleted row criteria: rows with specific text present. - Must complete as soon as possible. Ideal Freelancer Skills and Experience: - Experience in macro development, particularly macros for Excel or similar programs. - Strong attention to detail and a proven ability to interpret and implement specific criteria. - An ability to work quickly and efficiently to deliver the project as soon as possible. Feel free to ask any questions that will assist you in accurately pricing your b...
I have a aws cdk build project and need to set it up with Jenkins build so it should be deployed with Jenkins CI/CD build pipeline. so you need to guide me steps where to put cdk build project (i.e cdk deploy ) in stages
I'm looking for a competent web developer who is experienced with Odoo website builder to help me create 20 informational websites for various products. The main aim of these websites is to provide detailed information about each product. Key Requirements: - Development of 20 informational websites using Odoo website builder - Each website should be visually appealing and easy to navigate - The sites should be optimized for SEO to ensure they rank well in search engines - Integration of any necessary plugins or modules to enhance functionality - The completion of the project within a month Ideal candidate: - Extensive experience working with Odoo and its website builder - Proven track record of delivering high-quality, professional websites - Strong understanding of SEO best ...
I need a dynamic and interactive WordPress website developed using Laravel as the backend framework. The website will revolve around the concept of comparing fare estimates between ride-sharing services, specifically Uber and Lyft. Here are the detailed requirements: Fare Comparison: Implement a user-friendly interface with a search box that includes auto-suggestions for addresses. Users should be able to enter their pickup and drop-off locations effortlessly. Utilize the Uber and Lyft APIs to fetch real-time fare estimates for the specified route. Display the results in a clear and informative manner, allowing users to compare the fares side by side. Ensure that the API integration is secure and adheres to the respective API guidelines and rate limits. Redirect to Uber/Lyft: Onc...
Hey Mate, got a job for you. Please see attached sheet. Need to report on data sheet, data will be updated month to month. Not sure if this can be done with pivot table? but I'm not familiar with dealing with time calculations. Tab 1 Data table 1 + summary by driver: Average Total time (F) by driver (B). Tab 2 Data table 2 + summary by Sub function code: Average Total time by Sub Function (C). Need ability to exclude rows where F is blank or greater than 17 hours.
I'm looking for a professional Excel user with a strong grasp of nutrition concepts to develop an advanced tool for me. Here's what I need: - A comprehensive Calorie Calculator - Macronutrient Calculator to recommend the optimal amounts based on three different goals: Weight loss, Muscle gain, and Maintenance - BMI Calculator - Be able to calculate these based off body weight, height, activity level, age and gender inputs The ideal candidate should not only be proficient in Excel, but also have a good understanding of nutrition principles. The faster this can be completed, the better.
I'm looking for an experienced developer to create an e-commerce platform using Spring Boot. Key Requirements: - Full-featured user registration and login functionality - Intuitive product listing and search capabilities - Robust shopping cart and secure checkout process - Development of both the frontend and backend The target audience for the platform is retail customers. Therefore, the design and user interface should be consumer-friendly and engaging. Additionally, the project involves managing IoT devices. This requires a strong understanding of IoT protocols and integration within the platform. Ideal skills and experience include: - Proficiency in Java Spring Boot for backend development - Strong understanding of e-commerce website development - Experience with IoT de...
I'm seeking an expert in MS Power Automate, well-versed in implementing unique flows using different AI Chat APIs - particularly Chat GPT API and Cohere AI API. The primary task is to create a power flow capable of running batches of prompts effectively. Key expectations are: - Expertise in MS Power Automate, API integration, and AI-oriented applications. - Background in working with Chat GPT API and Cohere AI API. - Ability to deliver results on a web excel sheet. Please note that an understanding of additional AI Chat APIs is highly valuable for this project.
I'm seeking a highly skilled Korean video editor with extensive experience in cinematic editing for personal content. Requirements: - The ideal candidate should have extensive experience in editing personal content, which includes vlogs and lifestyle videos. Experience with cinematic editing is a must. Skills in color correction, sound editing, and transitions are also advantageous. - Proficiency in speaking and understanding Korean is essential, as the content is in Korean. Please only bid if you are an expert level video editor with a strong portfolio that showcases your cinematic and personal video editing skills.
I'm seeking a highly skilled Korean video editor with extensive experience in cinematic editing for personal content. Requirements: - The ideal candidate should have extensive experience in editing personal content, which includes vlogs and lifestyle videos. Experience with cinematic editing is a must. Skills in color correction, sound editing, and transitions are also advantageous. - Proficiency in speaking and understanding Korean is essential, as the content is in Korean. Please only bid if you are an expert level video editor with a strong portfolio that showcases your cinematic and personal video editing skills.
...the user to whom it was sent. If clicking on the link will enter the login information of another user, in this case it should not proceed. Configure the correct redirect to the necessary sites * insert a link to a document for download on one of the site pages (this document has already been generated and there is a download link on another page of the site) * Add generation of an invoice for using the site in pdf form (the form will be provided) with saving on the pages in the admin panel and on the user page. * Edit the account pages created in the admin panel, add a filter by user, month, account status and account number (these fields have been created, you just need to display them on the page). It should be possible to delete and download invoices, both individual docum...
I need an Excel 365 PowerQuery script that can fetch daily market data and handle potential data source interruptions or changes. I will be providing a URL that contains the market data, and you'll need to replicate the Google Sheets function =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). This function provides real-time data from the specified URL. Please note that the data is structured using HTML tags. Key requirements: - The PowerQuery should be able to be refreshed with the google sheet. - It needs to include robust error handling. If the data source is unavailable or the structure changes, the PowerQuery should not break but continue to function, ideally providing a notification that an error occur...
...related to their experiences with Uber and Lyft. This includes discussions on fares, driver/rider safety, and other relevant issues. Blog: Include a blog section where you can publish articles related to the ride-sharing industry, including tips for drivers and riders, updates on new features from Uber and Lyft, and insights into the latest trends in the industry. E-commerce: Integrate an e-commerce platform into the website to sell driver accessories such as phone mounts, dashcams, and other items that may be useful for drivers. Please note that you may need to use appropriate APIs and integrate them into your WordPress website to fetch real-time fare estimates from Uber and Lyft. Additionally, consider using a suitable forum plugin for WordPress to create the di...
I'm searching for a talented full-stack developer to establish an e-commerce site akin to Shopify but entirely focused on the upload and download of digital files. Key Functionalities: - Implement user registration and login feature. - Develop robust file upload and download functionality for various types of files: documents such as PDF, Word, and Excel; images including JPEG, PNG, GIF formats; and media files such as audio and video. - Integrate a highly secure and user-friendly payment gateway for transactions. Ideal Skills for this Project: - Proficient in full-stack development. - Experience in building e-commerce platforms, particularly with user account management and file sharing features. - Strong understanding of payment gateway integration. - Ability t...
...related to their experiences with Uber and Lyft. This includes discussions on fares, driver/rider safety, and other relevant issues. Blog: Include a blog section where you can publish articles related to the ride-sharing industry, including tips for drivers and riders, updates on new features from Uber and Lyft, and insights into the latest trends in the industry. E-commerce: Integrate an e-commerce platform into the website to sell driver accessories such as phone mounts, dashcams, and other items that may be useful for drivers. Please note that you may need to use appropriate APIs and integrate them into your WordPress website to fetch real-time fare estimates from Uber and Lyft. Additionally, consider using a suitable forum plugin for WordPress to create the di...
Need to import views, floor plans and cross sectons from Archicad 24 file. For some reason cannot get it in the program. Als oneedot save settings in the PLA file for a future use
...maintaining the manga art style. Your role will involve: - Creating detailed, expressive, and dark characters in the traditional manga style - Designing terrifying environments and settings - Setting the mood with your art and paneling - Working closely with me to ensure that the art matches the script It's essential that you bring a passion for horror and a knowledge of the genre to the table. Your work should be both visually engaging and contribute significantly to building the tension and atmosphere of the webtoon. Ideal skills and experience: - Proficient in manga art style - A strong portfolio of previous horror-themed work - Ability to work collaboratively and take direction - Strong understanding of paneling and storytelling - Excellent communication skills Th...
As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to delivering high qualit...
Hi we have small web application on PHP we have face issue to save or publish some data and some table shorting please bid if you can fix this quickly
I am looking for a freelancer with expertise in PowerBi and Excel. The task will revolve around creating a one-time report/dashboard on PowerBi sourced from a single Excel spreadsheet. The ideal candidate should have: - Previous experience with PowerBi and Excel - Proven track record of data analysis - Attention to detail Please note that the Excel file won't be changing over time, so there is no requirement for the PowerBi report/dashboard to be updated. Content Description: I have statistics from every UFC fight and want basic visualizations made (I have a rubric)
...related to their experiences with Uber and Lyft. This includes discussions on fares, driver/rider safety, and other relevant issues. Blog: Include a blog section where you can publish articles related to the ride-sharing industry, including tips for drivers and riders, updates on new features from Uber and Lyft, and insights into the latest trends in the industry. E-commerce: Integrate an e-commerce platform into the website to sell driver accessories such as phone mounts, dashcams, and other items that may be useful for drivers. Please note that you may need to use appropriate APIs and integrate them into your WordPress website to fetch real-time fare estimates from Uber and Lyft. Additionally, consider using a suitable forum plugin for WordPress to create the di...
Hi, I am in need of a skilled professional who is proficient in developing a Customer Service CRM with a key focus on the functionality of issue tracking and resolution. As the priority of the project, I require the CRM to systematically record and t...optimization The deliverable is a Web-based CRM application that is easy to navigate and meets all the desired functionality aspects. It would be added advantage if you have previously built CRM systems following a similar brief. This job requires an understanding of how customer service CRM platforms function, and I am eager to work with someone who can bring proven knowledge and experience to the table. The platform should also have capabilities to be improved for future adjustments. I am looking forward to some great proposals. ...
...existing SPSS tables to match APA 7th edition requirements, including double-spacing, 12 point-font, Times New Roman font style, and, if needed, notes under the table or necessary italicization or bolding of headers/keywords. Manual entry of descriptive text and data values to form each independent table is needed. In other words, raw data cannot be provided to manipulate or recompute in SPSS or any other program! The SPSS tables currently display: Table 1. 4 columns and 13 rows Table 2. 11 columns and 7 rows Table 3. 11 columns and 6 rows Table 4. 6 columns and 2 rows Table 5. 7 columns and 4 rows Table 6. 11 columns and 4 rows Table 7. 7 columns and 7 rows Total: 57 columns and 43 rows, where not all intersects consist o...
I need a power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: -Retrieve product ID, Quantity and Location -Gather specific production data including the production number. Ideal sk...-Proficient in DAX query language -Comprehensive experience with Power Bi -Excellent attention to detail -Previous experience in inventory data management will be a plus. What to do: I need to get a query in DAX (Power Bi) that gives me the same result as what I show in the excel file ( table ( column in yellow)). The excel file was obtained from the attached SQL query () The two screenshots show the power bi tables. I need to get a new column in power bi that shows me the results like in the yellow column in ...
I'm facing an issue with my Laravel admin panel, specifically a database table owner error that's occurring when uploading a zip file. - The error seems to be centered around the database table ownership. - The error happens during the process of uploading a zip file. - I can provide more details on the issue if required. I'm looking for a professional with experience in Laravel, database management, and debugging to help resolve this issue. The ideal candidate should be familiar with Laravel's database interactions and be able to navigate and troubleshoot these types of issues efficiently.
I want a python script that will check the balance of my four wallets inj1.... (injective blockchain), cosmos1.... (cosmos blockchain), osmo1.... (osmo blockchain) and juno1.... (juno blockchain) every 5 seconds. And in case the INJ balance increases, ATOM. OSMO or JUNO, then the entire balance will be transferred fully automatically to another wallet inj1...., cosmos1...., osmo1.... and juno1.....
FEATURES /FUNCTIONALITY Web responsive and no app should be required. Site should display correctly on all mobile devices. • Use PH7 Builder, free opensource dating-site software. I will not be using all available features, but you can see the capabilities and features here: • Implement my custom Algorithm to calculate matches based on selected filters • Require Chat messaging • Modify software to allow user to record audio and send as message or leave as bio • Profile pic can only come from user camera, not gallery or pasting • Require Match alert notifications • User should be able to exclude matches based on any particular filter/option • PH7 BUILDER Software can
I'm seeking an Excel expert to create a user-friendly data entry workbook. The job is straightforward and requires the following: - **Data Entry:** The workbook should mostly focus on simple data, like names and dates. I am not looking for any intricate calculations, formulas, or pivot tables. The main focus is on creating an Excel workbook that streamlines the process of entering simple data in a structured and efficient way. Experience in creating user-friendly UX within Excel is a plus. No integration with external systems or services is needed - this is a standalone project. I look forward to collaborating with an experienced professional who can deliver an effective, easy-to-use data entry solution within Excel.
I require AutoCAD shop drawings for the intention of construction planning for a commercial building. The freelancer should include comprehensive architectural details. A strong background in creating accurate AutoCAD drawings detailing architectural specifics for commercial projects ...accurate AutoCAD drawings detailing architectural specifics for commercial projects is a must. The desired candidate will need a strong understanding of construction processes, especially within the commercial realm, to ensure every detail contributes to a seamless build. Your craftsmanship will directly influence our build strategy, so we expect precise and detailed work. Please only apply if you excel in AutoCAD and have direct experience in the realm of architecture and construction of commercial ...
I'm looking for a seasoned Excel expert to create a set of macros that can automate my data extraction process. Here's what I need: - Automate data extraction: The primary purpose of these macros is to enable automated data extraction from local files. The data in question is stock market data. The ideal candidate for this project would have: - Proficiency in Excel: You should have a strong grasp of Excel, particularly in designing and implementing macros. - Experience in data extraction: You should have a track record of successfully automating data extraction processes. Looking forward to hearing from you.
I am looking for an expert in Excel to design a dynamic spreadsheet for project tracking. This spreadsheet will focus on monitoring task progress and deadlines. Key Features: - Daily updates: I will be updating task progress and deadlines daily, and so I need the spreadsheet to be user-friendly and efficient. - Task highlighting: If a task is falling behind schedule, I need it to automatically become highlighted in red. This will help me prioritize tasks and ensure no deadlines are missed. - This will need to show throughput for every phase and also provide an average through in volume. Skills and Experience: - Proficient in Excel - Experience in creating dynamic spreadsheets - Understanding of project management principles. I look forward to working with a detail-orien...
As the client, I require the services of a skilled copy typist who can accurately duplicate a PDF document. The original document contains tables, so a certain level of precision and attention to detail will be necessary. Your tasks: - Copy typing a PDF document - Transcribing tables as text - Ensuring 100% accuracy The ideal freelancer for this job has previous experience with copy typing and transcription, and is familiar with working with PDF documents and tables. A strong understanding of English and high attention to detail is imperative.
I'm in need of a freelancer capable of efficient and precise textual data entry into Microsoft Excel. This project requires a keen eye for detail, a high level of accuracy, and excellent organizational skills. You should be fluent in English and proficient in using Excel. To make an informed bid, freelancers should include the following: - Examples of past work related to data entry, particularly with Microsoft Excel. Stats that display the accuracy and efficiency of your work would be a huge plus. - Any relevant experience in data entry or related fields. Please note, attention to detail and Excel proficiency are paramount to this project.
For this task, I am specifically seeking a freelancer who is proficient at data entry and familiar with Excel spreadsheets. The project primarily involves numeric data, so accuracy is vital. Key Responsibilities: - Input numeric data into an Excel spreadsheet. - Maintain a minimum 98% accuracy level. Ideal Skills and Experience: - Proficient in Excel. - High attention to detail. - Experienced in numeric data entry. - Proven track record of maintaining high levels of accuracy. Please ensure you have the necessary skills and experience before placing your bid. I look forward to your detailed proposals.
I am urgently in need of an expert in Data Build Tool and SQLite database who can efficiently develop a data pipeline. The pipeline will handle extracting all files from a specific folder location on my local drive. The goal here is to create a pipeline that can universally extract all types of files. Ideal Skills and Experience: - Proficient with Data Build Tool - Extensive knowledge of SQLite database - Prior experience with data extraction projects - Quick turnaround time - Ability to work with local storage systems This is a two-hour assignment and the steps required for the task are detailed in the document provided. Your quick assistance is highly appreciated!
Need to extract data from website: , into an Excel file. Specifically name, discipline (medical practitioner, midwife, nurse, OT, physio, psychologist, podiatrist), location (incl suburb and postcode), initial registration date, registration expiry. There would be at least 100,000 rows of data. Only barrier, is this data is not able to be 'searched' efficiently. Individual names can be looked up. Or disciplines with a select number of names demonstrated...but I can't find a way to show ALL clinicians at once. Looking for a solution which can reliably pull all the names from the database.
I'm looking for an Excel expert who can build a simple yet effective sheet for basic arithmetic calculations. Key requirements: - Perform basic arithmetic operations: The main functionality of the sheet should be to perform basic arithmetic operations such as addition and subtraction. - Real-time collaboration: The sheet should support real-time collaboration, where multiple users can edit the Excel file simultaneously. Ideal skills and experience: - Strong background in Excel: The freelancer should have a deep understanding of Excel and the ability to create formulas for basic arithmetic. - Real-time collaboration proficiency: Experience in implementing real-time collaboration features in Excel will be highly beneficial. - Attention to detai...
I'm looking for a reliable and experienced data entry specialist who can assist me with entering data from images. The images will be directly uploaded to a website, and I need the data to be transcribed into various formats like Excel sheets, Word documents, and for copywriting purposes. Ideal Skills and Experience: - Prior experience with data entry from images - Proficiency in Excel and Word - Copywriting experience is a plus The primary goal of the project is to create a comprehensive database in various formats, so the ability to accurately transcribe and organize data is crucial. The chosen freelancer should have keen attention to detail and a high level of accuracy.
...potential clients. - Convert conversations into promising leads. - Record conversational details into our database. REQUIRED SKILLS AND EXPERIENCE: - Exceptional persuasive communication skills. - Proven experience in lead generation. - Familiarity with the corporate events and conferences sector. - A resilient attitude to handle potential rejections and keep going. This role demands someone ready to excel in a fast-paced environment while showcasing dedication, autonomy and agility. Your ultimate aim will be to assist in the company's expansion through the successful generation of potential leads. This is an excellent opportunity for someone looking to apply and enhance their telecalling skills while significantly contributing to a growing company in the event managemen...
I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.
...Chatgpt , no google Bard/Gemini, or any other AI tool. Cybersecurity CIA Analysis (2019-Present) Need in-depth analysis of CIA triad in recent research? 5 IEEE papers (2019-present) Comparative table with key insights âš¡ Fast, expert research & delivery Order now & unlock cybersecurity knowledge! Tags: cybersecurity, research, CIA, IEEE, analysis, comparison - Identifying potential vulnerabilities in multiple IoT in smart city systems - Analyzing existing cybersecurity measures - Proposing enhanced security solutions The ideal candidate will understand Security Challenges and Privacy Concerns while using IoT in smart cities, their potential vulnerabilities, and possible solutions. Your role would also involve aiding in comparison and assessment of different cy...
...documentation. We need a checkout option for Zelle and for Cashapp. These will be seamless just like checking out with credit card. The customer will select one of the two options and then they will be prompted to login to their account to complete the payment then upon successful payment they will be reverted to the payment success screen. Additionally you will add a field into the product category table and to the product add/edit pages in the admin panel for payment options allowed. Certain product categories can be paid with credit card whereas the others cannot. So something like cc_allowed and the answer would be y or n. Upon the options in the checkout if cc not allowed then this option won’t be available to the customer. You will do the above mentioned functional...
...enthusiastic business, we're seeking a talented freelancer who can design an effective Power BI Dashboard to integrate various data sources including Excel spreadsheets, CSV files, and SQL databases. The ideal freelancer would: - Have extensive experience with Power BI and DAX language integration. - Demonstrate an excellent grasp of designing dashboards that report on KPIs. - Be well-versed with creating DAX calculations in the Power BI environment. We require the dashboard to focus on specific metrics, therefore, a strong understanding of reporting on KPIs using DAX language is a must. Additional Skills: - Proficient in Microsoft Excel and SQL databases. - Understanding of data integration and reporting. - High attention to detail. We're excited t...
Tasks: We have three different algorithms for matching a resume with jobs on the website. They are coded in python. You have to create the APIs for webapplication. Then you create the Website which has 2 user types. Job Seeker and Employer. Login to use (home page) Job seeker will upload their resume details using a fixed form. Employer can post as many jobs using an upload job form. The data is stored in a table. On clicking the Find Jobs button (after uploading resume) or Find Profiles (for each job posting uploaded) the results page will show the ranked results (either job or resume depending on user). Home Page - Login SignUp buttons only...no design or banner or random stuff. Profile Page - Form Filling page with resume details. Resume Form Page Job Descri...
In search of a competent Excel specialist adept in Microsoft Access for multiple automation tasks. I need assistance with: - Macros Development: The main tasks include automation and creating tools. The proficient use of macros in daily operations is essential. - Report Generation: Specifically, the generation of technical proposal reports. Alongside this, the candidate should also be capable of automating the formula calculation process. Familiarity with financial, sales, and project status reports is an added advantage. - Tool Building: The capacity to build tools and other operations geared towards improving efficiency is crucial. Ideal skills include deep understanding of Excel functionalities, proficiency in Microsoft Access, extensive experience in automation via macr...
I need a Power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: - Retrieve Product ID, Quantity and Location. - Gather Specific Production Data including the Production number. Id...Proficient in DAX query language - Comprehensive experience with Power BI - Excellent attention to detail - Previous experience in inventory data management will be a plus What to do: I need to get a query in DAX (Power BI) that gives me the same result as what I show in the excel file ( table (column in yellow)). The Excel file was obtained from the attached SQL query ( ) The two screenshots show the Power BI tables. I need to get a new column in Power BI that shows me the results like in the yellow column in ...
I need an Excel expert to build a tool that can automatically validate and correct any incorrect country codes in the file. Requirements: - Replace incorrect country codes: The tool should replace the incorrect country codes with the correct ones. - Predefined list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates: Experience in creati...