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.
Solved! Go to Solution.
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
That works fine. I still have a problem that sometimes adjustments are more than one line, but I will figure that out. Thanks!