Find Jobs
Hire Freelancers

Build a data loop in Alteryx

$10-30 USD

Closed
Posted about 4 years ago

$10-30 USD

Paid on delivery
I have a need to load data in smaller chunks (from a database to another database), I have a list of months as a parameter that I would like to pass to an iterative loop that will run sql on one month at a time and then load the data to the output database and then loop back to the next month on the parameter list till end of the list (I have about 135 months). I have already tried using Dynamic input but it chokes when loading data as it is trying to do it all at one time. This needs to be solved using the Alteryx software. Thanks
Project ID: 24507564

About the project

10 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
10 freelancers are bidding on average $58 USD for this job
User Avatar
I  have more then 15 years of experience in SQL Server databse development and Administration. I have worked with medium to large mission critical databases. Worked for database design and performance tuning. I am also good for BI part like SSIS, SSRS and SSAS. I am immediate available to join.
$55 USD in 1 day
5.0 (5 reviews)
3.2
3.2
User Avatar
- I have working experience of more than 5 years in this field. -Looking to bring the benefits of data analysis to your business, with my skill in R Programming Language, Python(Numpy and Pandas), Machine Learning, SQL, Alteryx, Spotfire, Tableau, Microstrategy(Visualization)and MS Excel(Macros and VBA). - Additionally worked with Airflow(Email and Data Scheduler), Afterglow(DB and Visualization), Github(Coding Portal), etc. -with proper coding skills in Python, R, Pyspark, SMV, HIVE SQL, etc., I am well into Big Data so any kind of data can't challenge my skills -With the experience in customer retention, Supply Chain and Operations my analytical skills have delved into good business insights that can help the business. -Very good with statistics techniques, predictive modeling, clustering, forecasting models and data learning methodologies. -I worked with USA multinational healthcare giants such as Genentech, Aimmune, etc on various projects which makes me very comfortable to work within different aspects
$89 USD in 2 days
4.5 (2 reviews)
2.5
2.5
User Avatar
Hi, I understand you are looking for someone to do a loop using Alteryx to read 135 months' data one by one. I have expertise in similar task. Please let me know if you would like to hire me.
$55 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Will help completing data migration by using ETL methods and creating filters and applying advance functions
$100 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have been working on an analytics project where we will have to load 30 days of data. We could use macros or intermediate tables for looping. If Alteryx to DB connection is already established and set. It won't take more than 1 day.
$20 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I'm Himanshu from New Delhi, I'm an Alteryx Core Certified designer and Alteryx mentor. I have more than 2 years of work experience. I have worked on these types of requests and would love to help you with this one. I hope my offer works. Waiting to work with you soon. Best Regards, Himanshu
$88 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have 5+ years of experience and I am core as well as advanced alteryx designers certified data analyst. I have solution to your problem as I have done the similar project which needed to process daily transaction from flat file and to load processed data to Postgressql database. I used python script to write the data to db, as write to db operation is slow in alteryx and used batch macro to for loop. thank, Sonali
$30 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
This can be easily achieve! I have done similar kind of work for a client. I am alteryx advanced certified with 3 years of experience in Big4
$30 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Customer, I understand your requirement of loading data as several data packages sequentially to avoid performance impact. Let me work with you in solving this using Alteryx. Relevant Skills and Experience I have 10+ years of experience in data analytics. I have vast working knowledge in Alteryx designer core.
$90 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Frisco, United States
0.0
0
Member since Mar 20, 2020

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.