This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'll start by saying that this is my first post, and I hope I'll do a good job at explaining my problem precisely. Also, I did looked in the community, but didn't find exactly what I am looking for.
I'm extracting data from a website, have I'm having problems processing it to create a data table. So far I managed to extract one column which contains all my data (hundreds of rows). Each data record has a data followed by 11 variables. So row 1 = record 1 (or date 1), row 2 = record 1 and var 1... row 13 = record 2 (or date 2), row 14 = record 2 var 2, etc.
At the end I'd like to have the field "date" and the 11 variables in columns and as many records as I have rows. Attached is an Excel file which replicates the data structure, but you'll understand that in the real scenario data comes from a "download" web connector.
This can be accomplished using a combination of the multi-row formula tool and the Cross Tab tool. The attached example should get the data into your desired output. You could then change the column names to match what you are looking using a text input tool and they dynamic rename tool or using the select tool.
Hope this helps and let me know if you have any questions about the solution!
Hey @SBerube! Try the attached workflow where I used your sample Excel workbook. Note the workflow assumes that the amount of rows that belong to each date is fixed. Also, you will have to label the new columns, potentially with a Select tool after the Cross Tab.