Do you use Alteryx in a language other than English? If so, we want to hear from you! Please help us improve the international experience of our products by participating in this 5 minute survey.

We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Data split

mihaicom20
7 - Meteor

Hello everyone,

 

I am trying to find a solution in order to split a database in multiple part after a simple condition and I couldn't found a solution on the community. I need to set up the flow to take everything after a common key until it will find it again. Ex:

Col 1

Home

Street 61N

NO: 122

City: New York

Home

Street 122

NO: 332

City: Boston

I want this data to be split on 2 after and the key to me "HOME". I also I have attache you the database that I want to be split and it is split in multiple colours. The spiting key "Total OPEX 2021 - Run (Non-Compliance & Cyber)". Could you please help me with any advises? 

 

Thank you in advance!

Mihai 

 

 

3 REPLIES 3
atcodedog05
18 - Pollux

Hi @mihaicom20 

 

You can use formula like this to create blocks of your data on every occurrence of the key words. In your data split keywords suitable are "Total OPEX".

 

Workflow:

atcodedog05_0-1626434796782.png

 

Hope this helps : )

 

mihaicom20
7 - Meteor

Thank you so much for your help!

atcodedog05
18 - Pollux

Happy to help : ) @mihaicom20 

Labels