Enquiry on Relocation on Data in the Dataset

Question

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 PackageNumber of Vehicle Intake Without Retention PackageP-rate325 % 4614%

[After]

Number of Vehicle Purchased Retention PackageNumber of Vehicle Intake Without Retention PackageP-rate32546147.04%

Thanks a lot.

Best Regards,

Johnny

P-rate on Vehicle purchased Toyota RMP Contract_20220613.xlsx

Adrian_T · Accepted Answer

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 Answer

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

binu_acs · Accepted Answer

@johnnyycchan One way of doing this with the summarise tool