Structure unstructured data.

Hello Experts,

I am facing an issue and not sure whether it is possible in Alteryx, I have multiple files in which the file formats are different. As the number of columns , position of columns so not sure how to align these files. In the sample file I want to load second table from all the excels in which the formats are different , although and have some extra columns also. PFA with the sample files.

RSample1.xlsx

RSample2.xlsx

Preparation

Accepted answers

All comments

kmedici

Hi @ferha_jafri

Based on your sample data it's not clear what you're trying to achieve. Can you provide two files:

1) Your start data

2) What you want you start data to look like

This will help us understand what you're trying to achieve and what alteryx functions can be used to do so.

Cheers
Kris

ferha_jafri

PFA with the desired output, the output should have data one after the other which starts from second tabls whose start line is not fixed also.Not sure how to achieve this.

attachment

Great, thanks. And what about your start data?

The files you've provided on the initial questions does not contain some of the data in your desired output. For example, you initial data table includes the columns: