Split data into 2 streams

Hi

I have a simple xlsx file, with two seperate data sets.

So basicly I need to take the first part and create one stream, and then take the 2. part as a stream and then combine them.

But im not sure how to do that with the 2. part.

I have added a set of sample data. And highlighted the two lines which should be concidered headers for each data part?

Kind regards

Sample data.xlsx

Datasets

Accepted answers

RolandSchubert

Hi @Hamder83 ,

I'm not sure, if I understood the problem completely, but I assume, the two datasets are on one Excel sheet, separated by a header line, and entries for data have a numeric field [F1]. If that is true, you could set a "stream number" using a Multi-Row Formula tool, split using Filter tools and set the header using Dynamic Rename.

Sample workflow is attached. Will be interesting to see if I guessed correctly ...

Best,

Roland

SplitToStreams.yxmd

All comments

afv2688

Hello @Hamder83,

Could you please explain it better and five a maybe bigger example?

If not I am guessing you are looking for this:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

joshuaburkhow

Hi @Hamder83

THere are going to be tons of ways to do this. Here is just one 🙂

Hope this helps! If it does please mark as solved so others can find it on the community easily 🙂

Thanks!

Joshua

Split rows.yxmd

RolandSchubert

Hi @Hamder83 ,

Sample workflow is attached. Will be interesting to see if I guessed correctly ...

Best,

Roland

SplitToStreams.yxmd

olehr

Hi @RolandSchubert,

That solution was helpul. However, I did not quite understand the "IF STRCSPN.... function. Could you explain ? 🙂

Best,

Ole Henrik

Hamder83

Robert

Your a alteryx god!

Holy,

I know a lot comes with practice, but - how do i reach that level of knowledge?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703