Addition of data based on condition

Hi all,

I have a input column named Description.

My concern is, whatever the length of Description might be but the output of the length of description should be 40. For example, in the input what I have attached, the length of "A4 cell" is 14 but my expected output is 40 characters. Hence the difference here is (40-14=26). So these 26 characters I need as "*" in the separate column as mentioned in output sheet which is attached below. Is there any possibility for this.

Please help me with this. Herewith I have attached the input & output sheet.

Alteryx query.xlsx

Datasets

Accepted answers

Something like this?

1215-Gsiva3.yxmd

Hi @Gsiva3 , give this a try.

I hope this works, kindly mark this post as solution.

Thanks.

AdditionData-GS.yxmd

Adding a little bit of background explanation to @Qiu 's and @grazitti_sapna 's solution.

Since in your case padding needs to done on empty string. Both padLeft or padRight can be used.

Hope this helps 🙂

All comments

Something like this?

1215-Gsiva3.yxmd

Hi @Gsiva3 , give this a try.

I hope this works, kindly mark this post as solution.

Thanks.

AdditionData-GS.yxmd

Adding a little bit of background explanation to @Qiu 's and @grazitti_sapna 's solution.

Since in your case padding needs to done on empty string. Both padLeft or padRight can be used.

Hope this helps 🙂

Thank you so much. Got it!!!

Quick Links

Tags

This months top contributors

AkimasaKajitani 387

Hollingsworth 335