Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
ALTER.NEXT:

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
SOLVED

Shift data to next column

Highlighted
8 - Asteroid

Hi,

 

I have a issue with data in a CSV input, where certain fields have not been split due to the irregular data in in it.

Only 1 field is causing the misalignment of data for the many rows that have the irregular data, not all rows are affected.

 

Note: The data that is being input from CSV and is already being split by Alteryx via "\0" delimiter as i was getting "Too many fields in Record x", and also is going through a StripQuotes Multi-Field formula (Screenshot attached).

The issue is more to do with some of the data in the input that i am trying to accommodate.

 

Below is a mock up sample of the issue:

 

Sample Input

RecordData 1Data 2Data 3Data 4Data 5Data 6Data 7
1abc123Apples87623awee-878Red234.23
2qwe321Oranges324234awfd-234Red432.12
3lpo345Apples345bb",jh-123"Blue12312.43 
4asd876Grapes555543awgg-44Red 
5asd876Grapes555543aw",gg-44"Blue9876.1 
6qwe321Oranges4234te",fd-234"Red532 
7lpo345Apples99345dsjh-123Blue 

 

Desired Output

 

RecordData 1Data 2Data 3Data 4Data 5Data 6Data 7
1abc123Apples87623awee-878Red234.23
2qwe321Oranges324234awfd-234Red432.12
3lpo345Apples345bbjh-123Blue12312.43
4asd876Grapes555543awgg-44Red 
5asd876Grapes555543awgg-44Blue9876.1
6qwe321Oranges4234tefd-234Red532
7lpo345Apples99345dsjh-123Blue 

 

Thanks,,

Ash

Highlighted
14 - Magnetar

@akaash 
I think this might be what you want.1021-akaash.PNG

Highlighted
17 - Castor

Hi @akaash 

 

Since data issue is appearing on column Data4 hence fixing rows which has issue in this column.

 

Output:

atcodedog05_0-1603259665416.png

Workflow:

atcodedog05_0-1603259760745.png

 

Hope this helps 🙂


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

Highlighted
13 - Pulsar

Hi @akaash,

 

I have created a solution for you.

 

Emil_Kos_0-1603259594130.png

Output:

 

Emil_Kos_2-1603259676004.png


Please find my workflow attached. 

 

 

Highlighted
Alteryx Partner
Alteryx Partner

Hi @akaash , please refer to the screenshot and workflow attached along with this post.

 

grazitti_sapna_0-1603262222879.png

 

If this helps, kindly mark this post as solution.

 

Thanks.

 

Sapna Gupta
Highlighted
8 - Asteroid

Thanks all for the responses, I will go through the solutions and will report back which one works best with my data.

 

Cheers,

Ash

Highlighted
14 - Magnetar

@akaash 
Kindly note more than one accepts are allowed😁

Highlighted
8 - Asteroid

Thanks all, for the your suggestions

I finally got a chance to work through them and found one solution to work for my data. Unfortunately the other 3 would not work for me due to my data not being as clean as the sample data i provided.

- Multiple different headers (Prefix rename would not suit)

- Many columns (50+) after the field to split (renaming in formula or select would be a big task)

Highlighted
17 - Castor

Glad to hear my solution worked. Thank you for marking my post as solution.

 

Happy to help 🙂 @akaash 

 

Cheers and Happy Analyzing 😀

Labels