This week’s exercise is another example of how Alteryx can take poorly formatted data such as transactional log files and turn it into usable data.
Use Case: A customer has some data that comes with key product information stored at the top of the file. Each data column contains three lines of header information per product (product, market and type). The customer wants this information to be shown in rows for each product.
Objective: Reformat the input data to match the output example.
I separated the input into two streams by using the sample tool to select the first three rows, and skip the first three rows respectively. I then used the Transpose and Crosstab tools to pivot the data into the correct format, using the first three rows as a reference file. This was then linked back on the header type: