community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.9

The latest release includes several enhancements designed to improve your Community experience!

Learn More
SOLVED

Help with cleaning Data and convert rows to column

Meteor

Hello,

 

I am very new to Alteryx and with the help of this wonderful community I was able to scrape data from website and get to below format. I tried using data cleansing tool to remove " " from my data but its also removing the decimal point. I also tried other solutions from the community to convert rows to columns but looks like I am missing something. I have attached my workflow.Data.jpg

 

To format

 

nametickerclosePriceclosePricePrevWeekclosePrice52WeekHighclosePrice52WeekLow
Libor OvernightLIBORON2.388132.389382.394131.69688
Libor 1 WeekLIBOR1W2.421252.412382.4231.73875
Libor 1 MonthLIBOR12.493382.489752.522381.8775
Libor 2 MonthLIBOR22.561882.562382.652881.99788
Libor 3 MonthLIBOR32.59552.608752.823752.30031
Libor 6 MonthLIBOR62.669132.6732.907882.4524
Libor 1 YearLIBORYR2.732.745753.144132.66263
Alteryx Certified Partner
Alteryx Certified Partner

Hi @msve 

 

I will try to give you some hints:

 

- Removing quotes and backslashes - Formula Tool with ReplaceChar could help you with this task:

formulatool.PNG

 

- Preparing rows to convert to columns:

Multii-Row formula is adding an ID of 1 (start of the row) every time "name" appears in your dataset.

Multi-Rowexample.PNG

 

Cross-Tab to bring rows to columns:

You need to group by your Row ID field previously created.

 

cross-tan.PNG

 

I hope this helps.

 

Cheers,

Meteor

Thank you so much. I was able to create the workflow :)

 

WebSraping.png

 

Labels