Sql find missing values in a sequence jobs

I'm urgently in need of a qualified developer to create a pipeline utilizing DBT and SQLLITE. The goal is to process a multitude of json files housed in a particular folder. Please refer to the assignment document for detailed instructions Step 1. Initial Setup: ● Use DBT and SQLite to create a pipeline that processes files from a folder structure. You can access the folder here Step2: Adaptation for Continuous File Deliveries: ● Adjust the pipeline to handle continuous file deliveries, where new folders with JSON files are added over time. For example: Step 3: Data Quality Assurance: ● Create a suite of data checks to ensure the data is clean and add a DBT command to run these checks. ● Suggest additional inform...

I am seeking a proficient expert with skills in APA 7th edition format for configuring research tables. Even though proficiency in APA 7th edition standards is paramount in this project, having an insightful understanding of data organization and presentation will be appreciated. In this project, efforts will be channeled towards changing 7 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 ...

...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 skills: -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 ...

I am looking for a skilled developer to create a Windows-based application that can interact with a remote database. The application should primarily focus on retrieving and generating website sitemaps based on different criteria. The ideal candidate should have: - Proficiency in Windows application development - Strong experience in working with databases, particularly remote databases - Knowledge in data retrieval and data update functionalities - Ability to understand and incorporate additional requirements as the project progresses Please note that the selected freelancer may need to provide examples of past work and project proposals. Note: Application should be able to connect different type of databases such as MS SQL Server, MySQL...

As I plan on launching a website dedicated to reading the Quran, I'm in need of a UX/UI designer who could understand the significance of the Quran for Muslims and deliver an engaging and user-friendly design. Key Requirements: - User-centered Design: The website should be designed with the user's experience as the focal point. - Search Functionality: Must include a search bar for easy and quick access to specific chapters or verses. - Audio Recitation: An audio feature for recitation is essential to enhance the user's experience of reading the Quran. Ideal Skills: - Proficient in UX/UI Design: Experience in creating engaging, user-friendly interfaces. - Understanding of Muslim Culture: Knowledge of Islamic values a...

I'm seeking a skilled designer to revamp my company's profile. Key Points: - I'm looking for a modern and minimalist style. The new design should reflect a fresh, clean, and contemporary image for the brand. - The redesign should cover all aspects of the profile, including layout, graphics, imagery, and content. It's important that the new design is cohesive and consistent in its aesthetic. - The main goal of this redesign is to enhance our brand image. The profile should not only look professional, but also exhibit a sense of innovation and forward-thinking. Your Experience: - Proven experience in graphic design and content creation for company profiles. Samples of previous work with a modern and minimalist aesthetic ...

Please Sign Up or Login to see details.

...sys/kernel/jp6/tid also it also checks the device serial number using: getprop for this app the values are the following: tid:E200680D00004006D693381E (for both above commands) serialnum: 1fbc4d46 Both of these values have been hidden somewhere in this app along with these commands to check the device info to make sure they match. If they match the app works. If not the app will not properlt work. I need the location of the following variables that are somewhere in this app so that i can edit them: tid - E200680D00004006D693381E serialnum - 1fbc4d46 I want the commands to check against these values to remain so that by editing these values to the tid and serial numbers of the specific device it will check against those numbers an...

I'm in need of a logo for my upcoming marketing agency, the name of the agency is "Hardscaping Marketers". The agency is dedicated to working with hardscaping companies, who specialize in building patios, retaining walls, waterfalls, outdoor kitchens, and similar outdoor structures. Key Requirements: - The logo should be a blend of professionalism and results-driven attitude. - It should convey the core values of Hardscaping Marketers: * Professionalism * Results-driven - The logo should primarily convey a sense of trustworthiness and subtly hint at the results we provide. Ideal Skills and Experience: - Previous experience in designing logos for marketing/advertising agencies or within the hardscaping/landscaping indus...

I have the SQL file and main images of my current Wordpress site, and am looking for a professional to migrate and set it up on the new hosting account. We have the hosting account set up and will share the files with a dropbox link. Key Requirements: - Migrate current Wordpress site to a new hosting account - Setup and configure Wordpress in the new hosting environment - Ensure all site functionalities are working post migration - Provide login credentials for the access to Wordpress Please note: - There are no custom changes or updates needed during the migration - The new hosting environment is fully compatible with Wordpress Ideal Skills: - Proficient in Wordpress migration and setup - Knowledgeable in SQL databases and file h...

I am seeking expert-level assistance in writing a performance review to improve the efficiency of approval of time-card process within the deadline. The current recurrent issue is timecard approvals often not being done on time or missing punches. This severely impacts the operational efficiency, and payroll processing for all the employees and I need a plausible solution to remedy this. Key Requirements: - Introduce measures to prevent frequent delays in approving timecards. - Create reminders for the employees to approve time and make necessary corrections in case of missed punches. - Build a smart reminder system for the employee to review timecards

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...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 pul...

I'm looking for a freelancer who can create a modern and minimalistic logo along with a corresponding YouTube banner. The primary objective of these designs is for brand recognition. We want our logo to not only be visually appealing, but to also be memorable and representative of our brand and what we stand for. For the logo, I'm open to different ideas and color schemes, however I'm particularly leaning towards modern and minimalistic styles. This means I want a clean and simple design that can easily be recognized and associated with my brand. The YouTube banner should complement the logo and present a consistent brand image. It's essential that the design is eye-catching and engaging, as it will be the first thing viewers see...

...design for a new white 2024 Hyundai Elantra Hybrid Limited. I am a real estate broker with EXP Realty. In my market, my branding is pretty consistent and recognizable. It consists of social media videos, the dogs (two Alaskan Malamutes), my reviews, and my core values: education, communication, responsiveness. Design layout: This is to be a full car wrap – PLEASE NOTE: In my state we CANNOT put stickers on windows. A white 2024 Hyundai Elantra Hybrid Limited (designers can use a standard car for design) Looking online at the car design may be helpful. The car is White so please use that with the designs I would like to see the sides, front hood, and back end of the vehicle Prominent things I’d like to see on the des...

...automation system in Google Sheets for specific data from the NSE India website. Key Requirements: - Data Source: The data source will be '' - Data to be Integrated: Only the column titled '%CHNG IN OI' should be extracted. - Update Frequency: The automation should update the Google Sheets column once every day. - Data Display Format: The data in the Google Sheets should be displayed in percentage values. - Historical Data: No historical data tracking is required. The focus is solely on current updates from the source website. Ideal Skills: - Proficiency in Google Sheets and automation tools. - Experience with web scraping and data extraction. - Knowledge of data presentation and formatting in Google Sheets. - Abili...

As a business user, I need assistance with the configuration of SSRS Reporting Service on a staging environment. I have configured the WebPortal using Report Server Configuration manager and I am able to run SSRS reports from the Web UI. The project requires the following: 1. Automatically Scheduling of SSRS reports with default parameters. 2. Exporting the outcome of SSRS reports in a given folder every time a scheduled report runs I am experiencing the following issue while scheduling: Error: The SQL Agent service is not running. This operation requires the SQL Agent Service. You will need to help get rid of this error and set up scheduling and exporting of reports as mentioned. You will be required to get on a video call and...

As a data 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 ...

...design for a new white 2024 Hyundai Elantra Hybrid Limited. I am a real estate broker with EXP Realty. In my market, my branding is pretty consistent and recognizable. It consists of social media videos, the dogs (two Alaskan Malamutes), my reviews, and my core values: education, communication, responsiveness. Design layout: This is to be a full car wrap – PLEASE NOTE: In my state we CANNOT put stickers on windows. A white 2024 Hyundai Elantra Hybrid Limited (designers can use a standard car for design) Looking online at the car design may be helpful. The car is White so please use that with the designs I would like to see the sides, front hood, and back end of the vehicle Prominent things I’d like to see on the des...

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 Skills: - 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...

You can see in this google drive folder: I have two spreadsheets: municipalities and duplicates. The duplicate spreadsheet contains all of the records in the municipalities spreadsheet that are considered a duplicate. I don't need any help determining a duplicate, that has already been determined. What I need is for someone to go through the rows in the duplicates sheet, and find those rows in the municipalities sheet, and highlight them. You can see an example of what I mean in the two images attached here. the 'duplicates_examples' image shows a series of duplicate lines, and the municipalities_duplicated image shows those lines highlighted in yellow. That is exactly what I am loo...

We are seeking skilled proofreaders and transcriptionists (preferably English native speakers) to assist in completing and refining transcriptions. Your role will involve transcribing any missing sections and conducting a thorough proofreading of the existing transcribed parts. To expedite the process, we plan to distribute the work among multiple linguists, as these transcriptions are required urgently. Compensation for this project is set at $0.005 per word, whether for proofreading or transcription. Additionally, candidates must be willing to complete a small sample test as part of the selection process.

...will cost, not just to get in our inbox. We are a hosting company looking to automate our services through our WordPress site. This project involves two main tasks: creating a custom WordPress hosting management plugin and integrating Snipepay as a payment gateway in WooCommerce. Our hosting company currently sets up client accounts manually through a control panel that supports API integration. The successful development of this project requires extensive knowledge of this API to enable full automation of the account setup, hosting package ordering, and management processes directly from our WordPress site. The developer will need to ensure seamless communication between our WordPress interface and the control panel's API, enabling users ...

Hi Yasar W., I noticed you posted a following project ( https://www.freelancer.com/projects/sql/SQL-Expert-Needed-for-Data/details )

...obstacles—outdated design and poor user experience. - Outdated Design: Our website needs a modern, sleek makeover. Anyone who is up-to-date with the latest industry trends to give our website a well-deserved refreshing look, is encouraged to apply. - User Experience Upgrade: We're seeking a professional who can improve the layout and navigation of our website. A revamp that would turn website interaction into an engaging and hassle-free experience. We do not have specifics relating to any user experience issues except for a need for an improved layout and navigation. So, a broad understanding of potential UX pitfalls and user-friendly design savvy is crucial. The perfect candidate will have a background in the late...

We are seeking a highly organized personal assistant with exceptional communication skills to support our client daily tasks. Key Responsibilities: - Managing Email Communication: You'll be required to handle my inbox efficiently, prioritizing messages, drafting responses, and flagging important correspondence. - Scheduling Appointments: You'll handle my calendar, scheduling meetings, calls, and appointments as needed. - Researching Information: I often require quick, reliable research on various topics. Your ability to find accurate and relevant information will be crucial. Other Requirements: - Daily Availability: I need someone who can assist me daily, so please only apply if this suits your schedule. - Communication Tools: I prefer to communicate through emai...

Please Sign Up or Login to see details.

As a client with emphasis on quality, I need the support of an experienced Python programmer who can take charge of the frontend aspect of my web development project. At the core of this project are the following requirements: - Full proficiency in Python as the main programming language for the task - Demonstrated experience in frontend web development using Python - Familiarity with the best practices in Python programming - Capacity to effectively communicate, provide regular updates and accept feedback The missing response for the third question won't be an issue — I am more interested in a Python programmer who can bring their own unique ideas and solutions. You are encouraged to showcase your creative problem-solving ski...

...adept in R studio. The project involves approximately 3.5 million entries from an accounting firm's datasets and should follow the CRISP-DM framework. Responsibilities: - Data cleaning and preprocessing: Ensuring data is correctly formatted and that outliers, missing values, or inaccuracies are dealt with. - Exploratory data analysis: Extracting insights from the datasets, visualizing trends and discovering correlations. - Model development and evaluation: Carrying out predictive modeling and anomaly detection. Specifically, identifying potential financial transaction anomalies. More about the project: The goal is not predefined and can range from predictive modeling to anomaly detection based on what is discovered in the exploratory data analysis. ...

...performance issues. • Data Inconsistency: There's a rampant issue of missing and incorrect data circulating within the system. This issue impacts the integrity of the entire project and lowers its efficiency. I am seeking a professional who can help identify the source of the inconsistency and implement a permanent fix. • Performance Issues: I am dealing with certain performance issues, specifically very long database queries. Additionally, the task reassignment isn't functioning as it should, and data entry is also compromised. Ideally, I'm looking to enlist the services of a professional who possesses a strong background in database management and Spring Boot. Proficiency in diagnosing and fixing these...

...performance issues. • Data Inconsistency: There's a rampant issue of missing and incorrect data circulating within the system. This issue impacts the integrity of the entire project and lowers its efficiency. I am seeking a professional who can help identify the source of the inconsistency and implement a permanent fix. • Performance Issues: I am dealing with certain performance issues, specifically very long database queries. Additionally, the task reassignment isn't functioning as it should, and data entry is also compromised. Ideally, I'm looking to enlist the services of a professional who possesses a strong background in database management and Spring Boot. Proficiency in diagnosing and fixing these...

It’s Urgent! We need to write a shell script It’s too simple and not more than 2-3 hours job if candidate is good at shell script. It’s a small project but if we are satisfied we will give you more project in future . You thave to automate these task , Now i am doing this manually ---------------------------------------------------------------------------------------------------------- have to accept the subdomain as input and from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and bdomain

I'm looking for a developer who's proficient in C#, MS SQL Server, Dot Net, and XAMARIN to work on an already existing application. Need to improvise and add amend few things. Pls note we can pay maximum INR 4,000 for the work.

Scope of work, SureCart (high level). SureCart, SureTrigger, and SureMembers are powerful tools for creating and managing subscription-based platforms. Here's a detailed scope of work based on your requirements: Platform Setup and Configuration: Install and configure SureCart, SureTrigger, and SureMembers plugins/extensions. DONE. Set up payment gateways for processing transactions (Stripe, PayPal). DONE. Configure user roles and permissions for different membership levels (Freemium, Plus, Pro, Premium). Customize email notifications for user registrations, subscriptions, and other relevant actions. Product and Subscription Setup: Define and create payable products for each membership tier (Freemium, Plus, Pro, Premium). Set up subscription plans with varying features and ac...

I'm seeking a skilled Wordpress developer to create a website for my Auto detailing company. Despite skipping on some details, I'm clear about what I need: • A clean, professional and responsive website with three crucial pages - a Home page, a Services page, and an About Us page. (NOTE: All pages must load quickly and be mobile-friendly) Ideal Experience/Skills: • Proven experience with Wordpress website design • Understanding of efficient and engaging UI/UX principles • Ability to work independently as specifics on color scheme or design preferences are absent • A willingness to suggest design concepts due to lack of specified color or design preferences The application should include: • Past work sample...

I'm on the lookout for a highly-skilled graphic designer to curate a refined, classic and elegant logo and brand catalog for my business. This project aims to achieve three key outcomes: - Establish Brand Identity: The design should be unique and reflect the distinctive identity of my business. - Attract Target Audience: It should be compelling enough to capture the attention of our target demographic. - Reflect Company Values: The design should subtly convey the core values and ethos of my organization. Knowledge of industry trends and the ability to understand my business's competitive context is essential for this job. Key competitor to consider in design differentiation is 'Tanisq' malabar sanco kalyan. Ideal freelancers will h...

...Azure SQL database. One table has got 1:M relationship with another. In my form, I am trying to populate custom view in lookup field of this virtual entity lookup. I tried it in two different ways but it doesn't work. Method 1: I created fetchXML and link two tables, I get the result but issue is records don't filter in query. I tried this method with advance find as well, and again records don't filter according to criteria for virtual entity. in Advance find, if I try to select the columns from second table then I get error. Methos 2: I tried to create Fetch XML query and use addCustomView method. This method works if filter criteria is small. If I pass filter for say 50 GUIDS then this query does not return ...

As the developer of an existing project written in Python, SQL Server, and MongoDB, I am currently facing a challenge. A logical error in the code is causing a bug, and I need an expert to fix it. High-level summary of the code- 1. Fetch records from SQL server ( total 680000 records) 2. Apply face recognition on each record 3. Insert the response from step 2 in MongoDB along with other data from the SQL server Issue- The existing code is currently doing steps 1 & 2 and performing step 3 at last when face recognition is applied on all records. Due to this it step 3 is waiting to complete the step 1 & 2. Expectation- After fetching each record from SQL server, the code should apply face recognition and then sto...

It’s Urgent! We need to write a shell script It’s too simple and not more than 2-3 hours job if candidate is good at shell script. It’s a small project but if we are satisfied we will give you more project in future . You thave to automate these task , Now i am doing this manually ---------------------------------------------------------------------------------------------------------- have to accept the subdomain as input and from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and bdomain

I am in need of a multimedia designer who can create top-notch infographic short clips. These clips will be centered on promoting specific topics and corporate values to professionals within a specific industry. The visual style I'm envisioning for these clips is minimalist and clean with modern touches. Key Points: - The primary purpose of the clips is to promote specific topics and core values to a professional audience. - The ideal designer will have a strong understanding of how to create minimalist and clean styles with modern touches. - Experience in creating content for a professional audience. - The infographic clips duration: 5 of 12 seconds and 1 for duration between 1 and 2 minutes. Total 6 videography clips.

We need Oracle resource who are expert in below skills and having 8+ years of exp. Mandatory Skills: *• Need candidates with extensive experience in data migration across CRP, SIT, UAT, and GoLive phases in Oracle Fusion ERP implementation, utilizing ETL tools. * Experience in SQL Server, T-SQL, and SSIS Job Responsibilities: Data Extraction: * Extract data from various source systems, including flat files, spreadsheets, legacy databases, and external APIs. * Develop and optimize SQL queries and scripts for efficient data retrieval. Data Transformation: * Perform data cleansing, validation, and transformation to ensure data quality. * Convert data from source formats to Oracle-compatible formats. * Apply business rules and data mappi...

I'm in need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experi...

I'm in need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experi...

...possible... unless its deemed a rebuild is cost effective. The opencart system we use has been added and modified over time, hence it is not possible to simply upgrade to a newer opencart version. The business we operate in is parts for coal and wood fires, this is a business that is reducing overtime, due to environment issues, however, the stove market has recently had a mini boom due to gas prices being high with a record number of new stoves being sold over the last 3 years (we do not sell new stoves, just the parts for these stoves). We expect to see at least another 5 years from this business. We have been told by our current developers we should look at a google shopping program, however, we are concerned the margins are not ...

I'm looking for a skilled Python developer who is well-versed in machine learning and GANs to implement a conditional GAN primarily for image generation as a part of my school project. Key Responsibilities: - Utilize Python to develop a conditional GAN. - Find an academic paper from the last 5 years that enhances the vanilla conditional GAN using a simple approach and use this incorporate their approach to this one. - Find a dataset suitable for the task. It's up to you to choose one. Requirements: - Proficiency in Python. Experience using PyTorch machine learning library. - Understanding of GANs and how they can be applied to image generation.

I'm in need of a comprehensive business analysis report focusing on the following aspects: - **Main Objective**: The primary goal of this report is to identify our business needs, define the scope of analysis, and understand our current business context. - **Audience**: The report will mainly serve our project stakeholders, hence it should be tailored to meet their expectations. I believe that the stakeholders will find the following information most valuable: - **Market Trends and Analysis**: This will help them understand the external factors that may influence our business and its competitiveness. - **Competitor Analysis**: Insights into our competitors are crucial for making strategic decisions and staying ahead in the market. - **Customer Insights a...

I'm in the process of launching a fencing company titled 'Brothers in Arms Fencing' and need a stand-out, professional, and bold logo. Ideal Skills: - Graphic Design - Logo Design - Brand Strategy Project Specifications: - The logo should tie into our company name, incorporating elements of fences and arms. - Although I skipped the colors question, I'd love your creative input on this aspect. - The style needs to be professional bold, making a strong statement about our brand. Feel free to suggest a color scheme that you think would suit this style. Appreciated experience: Prior experience with entrepreneurship-oriented logo design is highly appreciated. I want this logo to reflect both the quality of our work and our...

I'm looking for an experienced designer to create a Mogrt for my golf scorecard in Adobe. The template should include: I have created the illustrator template but would like someone to create the Mogrt whereby I can edit - Text fields for player names - Hole numbers with corresponding par values - Fields for score input - Hole distance I would like the mogrt to be animated an either dissolve in or fly into the screen when it overlays my video footage Skills & Experience: - Adobe Suit proficiency, especially with Mogrt design - An understanding of golf scorecards would be beneficial - Exceptional design skills with a focus on clean, minimalistic layouts.

Hello, I am glad to submit the quotation for your requirement. Given the images of disks with holes, finding out missing spot (hole) numbers. The number of holes are 8, 6 or 4. Thanks.

I'm in need of an icon-based logo with a vibrant and bold color palette. Aesthetic should reflect a modern, bold font style. Ideal skills for this job would include: - Proficiency in graphic design software - A strong portfolio demonstrating creative icon-based logo designs - Experience in modern and bold typography - Understanding of color theory, particularly in creating vibrant, bold color palettes. We're seeking a creative and talented logo designer to develop a unique and memorable visual identity for our brand. The ideal candidate will have a strong understanding of design principles, typography, and color theory. Responsibilities: Collaborate with us to understand our brand vision and values...