Design Alteryx Workflow
Budget: $30 – $250 AUD
I am looking for someone to design an Alteryx Workflow which downloads and transforms a dataset on a monthly basis. Each month the attached file (asic (series-2a).xls) is updated on the ASIC website (shorturl.at/dCGNT).
I would like someone to design a Alteryx Workflow which:
1) Downloads the file from the website;
2) Identifies the last months worth of new entries;
3) Looks up the Liquidator details from the attached excel (Liquidators & Firms.xls) and adds as new column with the "IP No" and "Firm Key" of the Liquidator.
4) Outputs the new entries with added column for IP No and Firm Key to an output excel file in a standardized format.
I would like someone to design a Alteryx Workflow which:
1) Downloads the file from the website;
2) Identifies the last months worth of new entries;
3) Looks up the Liquidator details from the attached excel (Liquidators & Firms.xls) and adds as new column with the "IP No" and "Firm Key" of the Liquidator.
4) Outputs the new entries with added column for IP No and Firm Key to an output excel file in a standardized format.