Derived column transformation in ssisงาน

...When responding back, respond to the questions below, otherwise you will not be considered for the project. Freelancer – I will decide on the project in 3 days. The business evaluator estimates what your business is worth and offers a blueprint for scaling your business to the next level. The blueprint will establish your business baseline, identify your peer group, and advise you on what you need to do (people and budget) to accelerate to the next peer group level. Currently: 1) Written in MS Excel and utilizing Macros for a. Navigation between Sheets b. Set a subscription, 1st time the Worksheet is run, it writes a date in a database worksheet 2) There are 2 worksheets for Input: a. Customer Main Input Screen - worksheet (90% of the applicat...

...candidate will possess expertise in Perl, Python, and XML/XSLT, and should be familiar with MySQL. Responsibilities: Develop And Maintain Software Applications Using Perl, Python, XML, XSLT, And Database Technologies. Design And Implement Data Transformation Processes Using XML And XSLT. Write Efficient, Clean, And Reusable Code That Complies With Company Standards And Best Practices. Collaborate With Project Managers, Business Analysts, And Other Team Members To Understand The Requirements And Provide Technical Solutions. Perform Database Management Tasks, Including Design, Modifications, And Performance Tuning. Assist In The Integration Of New Software And Systems Into Existing Environments. Maintain Documentation For System Processes And Procedures. Participate...

I require a seasoned Python expert with specific skills in data analysis and scripting and automation. The key tasks will involve working with numerical data to accomplish two prime goals - data visualization and processing/transformation. Direct experience in the following areas is crucial: - Strong Data Analysis: Ability to dissect and interpret complex numerical datasets - Skilled in Scripting and Automation: Can systematically automate data processing and transformation tasks - Proficient in Data Visualization: Capable of creating intuitive visualizations to contextualize processed data Assured understanding of numerical data handling is a prerequisite. If the above resonates with your skills set, feel free to place your bid.

I'm in need of a professional who can help me with transferring specific project data from QuickBooks to SharePoint using Power BI Desktop. The primary goal is to leverage the integration capabilities of Power BI and create a seamless process for porting this data. Key Responsibilities: - Importing and transforming project data from QuickBooks to SharePoint - Setting up a system for recurring data transfer - Ensuring data integrity and security throughout the process Ideal Skills and Experience: - Proficiency in Power BI Desktop - Extensive experience in data integration and transformation - Prior experience with QuickBooks and SharePoint is a plus - Strong understanding of data security and compliance - Ability to create an efficient and scalable data tr...

I'm in need of a seasoned developer to build an OS/Android application that's applicable to mobile devices, tablets and company laptops. The main aim of the app is to facilitate the shift from manual logbook entries to a digital interface. Key Features: - Digital logbook functionality to create, view, edit and sort entries - User authentication and authorization capabilities - Data synchronization with cloud storage for easy access and backup purposes Your expertise in software development with proficiency in user interface design and cloud synchronization is necessary for this project. Prior experience in creating logbook applications or related software platforms will definitely be a plus. Be prepared to show relevant examples of your work and exp...

I'm seeking an experienced developer proficient in PHP Laravel for backend operations and Tailwind CSS and Vue.js for frontend tasks to enhance my webapp's functionality. Key Task: - automate Facebook sharing validation. Job Features: - Implement an auto-validation function using Facebook API to verify whether a shared content from the webapp to Facebook has actually been posted. - link this validated action with a coin reward function within the webapp. The goal is to validate if the content was actually reshared by our user before our system award them coins Separate the frontent input coin by adding new column Required Skills : - Expertise in PHP Laravel, Tailwind CSS, and Vue.js - Proven experience with Facebook API - Familiarity with developing rew...

...it'll to fetch rest row and column data from sheet. Check attachment. I'll enter only order number. This will involve: - Implementing a User Authentication system. Note that no specific features like social media authentication, two-step verification, or forgot password functionality are required. Just a simple log-in/log-out system will suffice. - Data validation will be key in this project. Each entry must be checked to ensure that it meets certain criteria before being stored in the sheet. - Real-time data synchronization between the app and Google Sheets. This means that any changes made in the app should be instantly reflected in the sheet, and vice versa. As far as the data types are concerned, we will be dealing with less th...

...aligning colors, fonts, and imagery with their LinkedIn profile. - Design a logo or update the existing logo to reflect the client's identity as an Agile Coach. - Develop a style guide that outlines the visual elements and guidelines for maintaining brand consistency across different platforms. 3. Marketing Campaign: - Conduct market research to identify the target audience and competitors in the Agile coaching industry. - Develop a marketing strategy and campaign plan tailored to the client's goals and target audience. - Create engaging and informative content, including blog posts, articles, case studies, or whitepapers, highlighting the client's expertise. - Utilize social media platforms, such as LinkedIn, Twitter, and relevant industry forum...

I'm seeking a talented artist to help me with a small photo manipulation task that I need completed ASAP. Key Aspects: - Photo Transformation: The task involves removing an existing person from a picture and seamlessly inserting a new image of myself into it. - Time Sensitivity: The project is urgent, so I need someone who can complete it promptly without compromising on the quality and details. This job requires a skilled hand in photo editing software and a keen eye for detail. Your ability to make the image look realistic and natural is crucial. Experience in similar photo manipulation tasks is highly appreciated. If you think you're up for this challenge and can deliver a top-notch result on a quick turnaround, I'd love to hear from you.

...along with a host of other merchandise. The potential graphic designer should bear in mind that these products are aimed to appeal both adults and children. I am interested in hiring a graphic designer to help transform my mother's artwork into designs suitable for various products. Her paintings predominantly feature elements such as birds and flowers, and I envision creating patterns from these elements that can be applied to a range of items including travel mugs, yoga mats, phone cases, cushion covers, and more. The goal of this project is to create visually appealing designs that capture the essence of her artwork while also being adaptable to different product formats. I believe your expertise in graphic design and your ability to translate artistic...

...Page, Column A -I want to be able to select room type from a dropdown menu, and input the revenue for different room types on the Revenue Target page. Room types are Private Room, Shared Room, Shared Medicaid. Employees Page, Column A -I want to select employee job type from a dropdown menu for each employee. There are 22 employees, and the Employee job types are: Caregiver Med Tech, Caregiver Non-Cert., Kitchen Chef, Kitchen Staff, Nurse, Bookkeeper, Administrator, Director, Admin Assistant, Activity Director, Maintenance Worker, Driver. Also, I would like 4 blank rows at the bottom where I can add new employees if needed. Shifts Page, Column A Row 14 -Change Shift Types to match Employee Job Types above. -Add 10 blank rows where new shifts can be added. S...

I'm looking for an expert in VBA and macros to help streamline my processes in Excel. Key Requirements: Shifts: Defined two shifts in the "task tap": Morning: 6:00 to 15:30 Afternoon: 14:00 to 22:30 Quality: Updated the agreed-upon columns in the "quality tap." And remove the error code if there is no any number Delays: Ensured delays are reflected as discussed. Task Order: Arranged tasks in the "task tap" from oldest to newest. Please review the file and let me know if you have any questions or require further changes. Requirements: 1- Required an option in this file (Excel) that when the planner change the completion date of any task in column K in the TASKS tap, th...

Hi HashOne Creatives: A number of years ago, you created a site for me at in wordpress. The site works, but I cannot get a number of the plugins to work. I was wondering if you could help fix it. Once it's working properly, I'd like to clone the site.

...deploy a customized color palette to my SharePoint Online site that aligns with my specific brand identity. Proficiency in SharePoint is non-negotiable, while understanding in Visual Studio Code, CSS, and Javascript will be advantageous. Key tasks include: - Implementing the color palette based on my comprehensive brand guidelines. - Ensuring the aesthetic cohesion of all elements post-deployment, including text, headers, links, and buttons. - Conducting a final review to ensure the visual appeal and alignment with brand guidelines. You must work independently and efficiently as the brand guidelines are clear and straightforward. Attentiveness to specifics and astute skills in integrating these guidelines will ensure seamless alignment with brand identity. Demons...

...want to make a small mascot for our company that we can use in company merchanise (e.g. on t-shirts) and other visual communication. We have a logomark that's round (see attached), so I was thinking whether we could make it into a mascot like "Miss Minutes": In terms of the "poses" of the mascot, it could either be with

generate panel with graphics, such as, pie, bar column. with asp.net

I'm looking to create a detailed list in Excel from the website AND filtered by clicking on 'Hardware' under 'Products' which is on the left side in the 'Filter' section. The list should have two columns - the first for the Company Name and the second for the Description available on the website. Key Requirements: - Copy the Company Name into Column 1 and the Description into Column 2 of the Excel sheet. - Description should be directly copied from the provided URL. Ideal Skills and Experience: - Proficient in Excel and web scraping. - Attention to detail to ensure accurate data transfer. - Previous experience with similar projects would be advantageous.

...blog page that I need rectified with expediency. The primary problem is that the images on my blog are not displaying in the correct manner. Instead of the intended multi-column layout (3-4 columns on desktop), my blog's images are displaying in single line and the entire layout appears squashed to the left on mobile devices. Additionally, new blogs are not updating to the top of the queue as they should, adding to the overall problem. I do have a specific design in mind to address these issues and I would appreciate it if we could adhere to it in order to maintain the unique aesthetics of my blog. Ideal skills for the job include: - Extensive experience in HTML/CSS, JS: able to tackle layout and formatting issues - UI/UX desig...

I'm looking for a freelancer who can write a 12 liner poem for me in Tamil. The poem should be derived from a video I share with you. I have 100 videos and budget is 1500 only... Only if you are aware of tamil language you can do that otherwise you cant do that. Dont ask for increase budget

Need a react native app and laravel developer who can make changes in mobile application and its backend web admin panel: 1. Need each project description 1 or 2 lines at the very beginning before the containers and need an option in backend panel to enter that info 2. If we go into each interest or project we will see multiple campaigns here first of all i need all this campaigns in a line one after another or in a column and now each campaign will have its own set of pictures which user can see via slide 3. Further i want to change the look and feel of the container i have reference available 4. Secondly each user has its own donation history which you can see right here i want this particular rows showing particular transaction clickable through wh...

I'm seeking a detail-focused freelancer, ideally with proven experience in file transformation. The task is to convert every page of a PDF document into separate JPG files, all visuals must be at 300 DPI resolution. Key Requirements: - Convert each page in the PDF into its own high-resolution JPG file - Maintain a constant resolution of 300 DPI for all pages - Ensure the original quality and layout of the PDF is retained in the JPG output Skills and Experience: - Experience with file conversions - Attention to detail - Ability to maintain high image quality during conversions - Fluency in English for effective communication Success in this role will be measured by the quality of the converted JPG images and adherence to the project requir...

...requirements: - Predominantly utilizing shades of blue and green. - The design should be in line with the digital/technology field, preferably with a touch of modern/simplistic style. - We want our icon to say Digital but Stable/Scaleable/Secure (which is our slogan). We would prefer the logo to be simplistic so easy to remember. Words that describe what we do: Innovation, Digital transformation, driving efficiency through technology, The blue and green reflects our commitment to sustainable technologies. We would need different versions of the logo for different print media. Ideal Skills: - Prior experience with brand identity and logo designing. - Knowledge and understanding of current design trends especially in digital/technology sector. - Detail-oriente...

We are seeking a highly skilled Node.js developer with experience in building text streaming applications. The project involves developing a robust and scalable text processing pipeline that can handle [briefly describe the data source and volume]. Key Responsibilities: QA Existing Design and implementation of our Node.js application for efficient text stream processing. Build functionalities to for data cleaning, transformation, analysis. Check mechanisms for error handling and logging. Ensure the application is scalable and performant. Provide clear and concise points what is Ok and what can be improved. Required Skills: Strong experience with Node.js development. Proficiency in text processing techniques (e.g., regular expressions, text manipulation). Familiarity...

Get value from one column from another table only. Able to work with ftp. Just this issue

I am in need of an Excel relational database. The database should have the functionality to enter values automatically from an attached worksheet. The entry of these values will be based on specific criteria, more specifically, column values. Required Skills and Experience: - Strong knowledge and proficiency in Excel - Experience in database creation, management, and optimization - Understanding of data entry and data analysis - Proven experience in creating reporting capabilities within Excel. Using the "Reference data" tab, when the value in Column B is entered in the "Example worksheet" the corresponding values should automatically populate - Tariff code, Duty rate, CPF.

...automate these processes to boost our operational & technical efficiency. project SOW: 1- build excel sheet list of company support of oil & gas upstream automation processes. first from UAE local company than find global company (list include: company name & type of tools service & description service tools & contact (website) 2- check the attachment excel, you will find the overall job & activity in oil company & type of tools need & find more activity + tools support. 3- find company build dashboard can service all tools depende of division & find solution to connect system tools together 4- flowchart of activity team with tools support - To explain 5- prepare 3 presentation power point for 3 level of position (high level management posit...

I need a proficient structural engineer who can deliver a General Arrangement (GA) drawing and ...Cement Concrete (RCC) beam. The task at hand involves a cantilever carporch of 3.5m x 6m dimensions, destined for vehicle parking. I'm picturing an industrial-style steel beam that will be supported over an existing 250x600 RCC beam, which itself sits atop an RC column. Importantly, the carporch won't be subjected to any extra weight besides the vehicle. Your experience and skills: - Mastery of industrial design style - Proven experience in RCC and steel structure design - Proficient in providing design verification - Knowledgeable in GA drawing - Able to optimize for weight and structural stability Your main deliverables: - A GA drawing of the structu...

I'm looking for a skilled designer who can help me turn a photo into a vintage-style logo. The end result should be suitable for use both online and in print. Key requirements include: - Ability to create a vintage-style logo - Proficiency in converting a photo into a logo - Understanding of designing for both online and print applications - Experience with neutral and earthy color palettes

I am struggling with incorrect results when attempting to subtract two values in a column of clock times in Excel. My data is in a 12-hour clock format, and I signify AM and PM directly within the time cells. I require an expert in Excel to address this issue promptly. To take on this project successfully, you should have: - Proficient Excel skills - Solid understanding of the 12-hour time format and functions in Excel - Ability to troubleshoot and rectify the problem quickly

...have just filled in and removed, surrounded on various sides by a deck, lawn and other unused space. I have attached several videos and pics to show the same, and would be happy to provide measurements, more pitctures and videos etc as needed. We want to turn the backyard area into a serene, inviting relaxing space. Some ideas could include the installation of a fountain, the laying of pavers, fire pit, application of artificial turf etc. but I am looking for other suggestions as well. Primary purpose of the project is radiating relaxation, for use by friends and family. I am completely open to suggestions for materials. Ideal skills & experience: - Landscape design - Hardscaping - Material knowledge - Ability to present innovative ideas for the space - Prior experience ...

I'm seeking an Apple Script expert to help me automate a specific task in Numbers. - The task involves splitting a single column of four-digit numbers into four separate one-digit columns. - The split should be done in a sequential order, meaning the first digit of each number will go into the first separate column, the second digit into the second separate column, and so on. Ideal Skills and Experience: - Proficient in Apple Script - Extensive experience in automating tasks within Numbers - Strong understanding of data manipulation and processing

AI Implementation: Business Transformation Keynote Speech

I'm seeking an eloquent speechwriter with an intermediate knowledge of AI &...business to successfully adopt and implement AI technologies. Key elements include: - Clear articulation of AI's role in business transformation - AI projects are project regarding people and change management - AI its a matter of culture - AI projects are different from digital innovation projects, AI project must be managed according to Innovation management principles - Comprehensive approacch to AI incorporation in businesses Ideally, you've had previous experience in crafting speeches or articles on similar tech-based themes. Time is of essence as I need this keynote speech ready ASAP. Your ability to marry technical knowledge with relatable examples will be...

I'm looking for a professional with high proficiency in Photoshop, who has sophisticated understanding of textual content handling. You need to be able to achieve two significant tasks: 1. Text Overhaul: - Entire sections of the document need rewriting. - Formatting and style changes are also required. 2. Image Amendment: - Essential changes to the images are also required, to match stylistically with the text alterations. Ideally, you should have prior experience in document design and complex photoshop tasks. This job is not for a novice but for someone who appreciates the challenge of a complete visual and textual transformation.

...accurately detect the edges of rugs in images where the rugs are on a transparent background. Transform these images so that the rugs are reshaped into perfect rectangles, despite the presence of natural waves, curves, and optional fringes. Ensure that the transformation maintains the integrity and quality of the rug design, especially when fringes are involved. Provide documentation and support for integrating the solution into an existing Python workflow. Requirements: Proven experience in image processing and computer vision. Strong proficiency in Python, especially with libraries such as OpenCV. Ability to handle images with transparency and complex patterns. Excellent problem-solving skills and attention to detail. Previous experience with similar tr...

I'm looking for an urgent build of a program to visually present and evaluate the quality of images in a Word document or PDF. The key features and functions of the program include: The objective is to develop a user-friendly program that organizes and presents images sourced from Word documents or PDFs. On the interface, Part A images will be displayed on the left side, while corresponding Part B images will be arranged in a tile layout on the right side. Filtering will be based on the presence of the "AAA" substring, and users will have the flexibility to choose the sequence of "AAA" substring images they wish to view—either the first, second, or third occurrence. The program will enable users to assess the quality of the Part B images and pro...

...then by property address to find the email. Once the email is located append it to the row in column AW. Once completed, prefix “processed_” to the file name. Api to use: skip force Key Requirements: - The script should be able to scan a specified Google Drive folder for files. - When a file is found, the script should process it by skip tracing. This involves cross-referencing the information in the file with first names and last names, company names or property addresses. - The script should be able to handle files that already exist in the specified folder. - The script should be robust and reliable, able to handle a large number of files efficiently. Ideal Skills and Experience: - Proficient in Google Apps Scripting - Experience ...

...file names and other info are stored in the “files” table of the mysql database. All of the above works with no problems. Once the actions above are complete, a button at the bottom of the dashboard page is activated. When the button is pressed, PHPSpreadsheet is used to move the data from the Excel files in the “upload” folder to tables in the database. This is done in a similar way for all files and up until a couple of months ago, worked fine for all files, and then suddenly stopped working for only the largest file. Through my own tests, I’ve learned that if I remove the 30 columns prior to the last column in the problematic Excel file, it transfers fine, so it’s not a coding issue. There’s ei...

...relevant date column of the "ORDERMENTUM" tab in the google sheet. See sample production report attached () - this is for the items required by customers on Saturday May 4th. This data is not available to access without exporting it to a csv file. For retail orders we use Shopify but use two apps to provide the data to our production team so that they know when the customer has selected to pick up their order - Zapiet Pick + Delivery to assign an order pickup/delivery date (it does so by adding date tags to orders) and Report Pundit to organise this information into production reports. See an example Report Pundit export for Sunday May 5th (Production - Daily ) This data needs to populate into the relevant date column of the "SHOPIFY"

Looking for an expert in PCB design with hands-on experience in Fusion 360. I have completed a schematic that requires transformation into a PCB layout, adhering to several specific constraints. I am expecting: - Proficiency in Fusion 360. - Ability to accurately follow detailed instructions related to layout constraints. - Extensive understanding of PCB fabrication processes, more specifically conventional PCB fabrication. So, if you consider yourself an seasoned PCB designer with the ability to follow precise specifications, I would love to hear from you. Join me in bringing this project to fruition.

I need a knowledgeable Excel VBA specialist, with a background in data manipulation and analysis, to create a custom macro for my spreadsheet. - The macro's primary function is to automate the creation of new rows based on certain numeric values, namely the ones found in columns E to L on a specific sheet in the workbook. - Upon row creation, data from columns A to D should be copied over to the corresponding new row on another sheet. - Additionally, the macro should automate the assignment of values in cells from L to Q based on the count of numbers in rows created. The assignment of values is to be done using a simple addition or subtraction formula. The ideal freelancer should have solid experience in creating advanced Excel VBA macros...

...As we embark on this transformation, we recognize that our brand identity is more than just a logo—it’s the heartbeat of our organization. We invite passionate professionals to join us in shaping a fresh, memorable, and impactful brand that resonates with our audience. Requirements: - The new design should have a modern, fresh and clean look - The color scheme should be green and brown - The main goal of this rebranding is to refresh the company's image. Ideal skills and Experience: - Proven experience in logo design - A strong sense of modern design trends - A good understanding of color theory, particularly in the use of green and brown - Excellent typography skills, particularly for modern styles. Please include samples o...

Linking of dropdown with another column. Work with ftp only.

...Journals of International Law. Provide the journal's website and email address in this column. 2. Publication cost: The journal's publication cost APC must be cheaper or free. Please write the publication cost per page. Don't mention any journal that exceeds thirty dollars per page. 3. Status: The journal must be Indexed with Research Gate, Google Scholar, Academia, JSTOR, etc. 4. Ranking: Mention the international ranking of the journal. 5. Nature of journal: Legal articles, academic research papers, international law areas, including human rights, international trade, international humanitarian law, peace, security, and conflict. **Please Organize the information in a table format. Each journal should be listed in a separate row, with the ...

I'm seeking a proficient developer to build a comprehensive demo or starter code integrating Snowflake and Kafka using AWS cloud. The ideal candidate should have deep understanding of concepts such as: - Data ingestion - Data transformation - Data storage and retrieval The code should ensure: - Optimal performance - Scalability - Security The code can be written in Python or Java. In-depth knowledge of these languages, as well as experience with Snowflake and Kafka integration, is a necessity for a successful bid on this project.

I am seeking a detail-oriented freelancer to input text and numerical data into 3 small Excel spreadsheets, containing 1 column each. 2 spreadsheets for emails, one called Minnesota, one called Midwest. 1 spreadsheet of inventory numbers. See attached. Only emails are needed. Inventory is on yellow paper Ideal Skills: - Proficient in Excel - Attention to detail - Knowledge of data organization and management Highlight the entries that you are not sure of, or the handwriting is to difficult to read. English fluency in a must.

I'm in need of an experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Excel files, CSV files, and SQL databases - Transformation of data, including extraction and update of parameter values from Data Models in each Workspace Ideally, the freelancer would carry a strong understanding and hands-on experience with PowerShell scripting, Power BI, data transformation techniques, and working with database source files like Excel, CSV, and SQL formats.

...advanced features such as column selection, filtering, sorting, pagination, and complex table relationships like aggregations and master-detail references. Core Requirements: 1. API Framework: The API should be developed using .NET 8. I am open to using either OData or GraphQL for the API architecture, depending on what the developer finds most suitable for the project requirements. Alternative suggestions are welcome for discussion. 2. Generic Controller: The API should feature a single, generic controller that can dynamically handle all tables within the database. This approach requires sophisticated coding to manage CRUD operations generically across all tables. 3. Metadata-Driven Architecture: The database tables' metadata will be managed externally and stored in...

I am in need of expert interior designers with a flair for creating stylish, sophisticated spaces that evoke a neoclassical appeal. The project involves the aesthetic transformation of specific areas in my penthouse: - Bedroom - Walk in closet - Restroom - Entrance/foyer - Jewelry room The color scheme preference is neutral tones, so you'll need to integrate this subtly with the design elements. Key competencies include: - Proficient in neoclassical interior design - Demonstrable experience in effectively applying neutral tones - Experienced in designing spaces that are both chic and practical - Knowledgeable in current design trends for high-end spaces - Excellent understanding of space planning and layout Your portfol...