Enquiry on Relocation on Data in the Dataset

[johnnyycchan]

Hi all,

May I know how to move the figures into 1 line by using Alteryx to fix the issue. 

[Before]

Number of Vehicle Purchased Retention Package	Number of Vehicle Intake Without Retention Package	P-rate
325		%
	4614	%

[After]

Number of Vehicle Purchased Retention Package	Number of Vehicle Intake Without Retention Package	P-rate
325	4614	7.04%

Thanks a lot. 

Best Regards,

Johnny

[Adrian_T · Accepted solution]

Hey @johnnyycchan,

Depending on the complexity of your actual full dataset, your approach might be a little different. Given your example dataset I have used the Filter Tool to separate columns and the Data Cleansing Tool to "Remove Null Columns".

Example workflow attached. :)

[Kurohits · Accepted solution]

Another way of doing that. As @Adrian_T  said depends on the complexity of the dataset. Please accept this as a solution if this solution worked for you.  

Thanks 

Rohit Gupta

[johnnyycchan]

Hi Adrian,

It works. Thanks a lot. 

Best Regards,

Johnny

[johnnyycchan]

Hi Gupta,

It works. Thanks a lot.

Beat Regards,

Johnny

[binuacs · Accepted solution]

@johnnyycchan One way of doing this with the summarise tool

[johnnyycchan]

HI binuacs,

It works. Thanks a lot. 

Besy Regatds,

Johnny