Splitting Records for Processing according to row data

[pootowoh]

Hi, I am sorry if this has already been responded, I searched and did not find anything.

I have a data set that appended multiple files, I now want to use Alteryx to separate the individual streams, process and put them back together. The part which is holding me up is separating them,

So the Datastream has one column that indicate the source, I could filter it out, however the number of sources varies according to the day the processing is being done. I have something like this

Name	A	B	C	D	E	F	G	H	1
Value	dvA	dvB	dvC	dvD	dvE	dvF	dvG	dvH	1
Adjustment	daA	daB	dvC	dvD	dvE	dvF	dvG	dvH	1
Name	12	13	14	15	16	17	18	19	2
Value	dv12	dv13	dv14	dv15	dv16	dv17	dv18	dv19	2
Adjustment	da12	da13	da14	da15	da16	da17	da18	da19	2

I need to transpose this to become something like

Name	Value	Adjustment
A	dvA	daA
B	dvB	daB
12	dv12	da12
13	dv13	da13

The problem is if I transpose the data set it will only get the first instance and not the others. The only way I see this working is if I split the data when it finds a new source, transpose and then joining them again (if you have another suggestion, I'm open to it).

I tested with multiple filters, but I need a more generic solution that would work for a different number of entries, anyone knows if this is possible?

It is not possible for me to get the separate sources.

[MarqueeCrew · Accepted solution]

@pootowoh,

This approach does create the desired results for you.  It separates the data based upon the rows being {Name, Value, Adjustment} and constructs the data according to the row number {1}.  The first row of data read is in the first row (not a fieldname).

Cheers,

Mark

[pootowoh]

That works fine. I still have a problem that sometimes adjustments are more than one line, but I will figure that out. Thanks!