Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Shift data to next column

aka_ash
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

8 REPLIES 8
Qiu
20 - Arcturus
20 - Arcturus

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

atcodedog05
22 - Nova
22 - Nova

Hi @aka_ash 

 

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 😀👍

Emil_Kos
17 - Castor
17 - Castor

Hi @aka_ash,

 

I have created a solution for you.

 

Emil_Kos_0-1603259594130.png

Output:

 

Emil_Kos_2-1603259676004.png


Please find my workflow attached. 

 

 

grazitti_sapna
17 - Castor

Hi @aka_ash , 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
aka_ash
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

Qiu
20 - Arcturus
20 - Arcturus

@aka_ash 
Kindly note more than one accepts are allowed😁

aka_ash
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)

atcodedog05
22 - Nova
22 - Nova

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

 

Happy to help 🙂 @aka_ash 

 

Cheers and Happy Analyzing 😀

Labels