How to distribute text/numbers in one cell to multiple cells?

Hello Alteryx,

I am currently working on filling up a tax form in excel format.

I have some columns in the input file that I wanted the content of each cell to be distributed to multiple columns before entering them in the form using BLOB tool.

Ex. Period like 10012024 (which is October 1 2024 - 4th quarter) to be distributed in column 1 up to column 8 and will use blob tool to automatically fill in the tax form (from each row).

May I know how will I do that? Thinking of the text to column tool as the solution but there was no delimiter for that. Or do you have a better solution in mind that you can share, please let me know. Attached is the sample output and tax form.

Please refer to my dummy output.

tax_form_.PNG

dummy_public tax form.xlsx

Developer Tools

Input

Topic of Interest

Tips and Tricks

Accepted answers

Raj

@PassION_es
there are some points to look here
1 - I have assumed that you will be having n number of lines, so the point of batch macro came in
2- there should be a template of form which you want to fill out for each record
3- using blob tool you will be creating a file for that record with user id including into it
4- once the copy is generated using blob you will use that path to write data
also i have kept the formatting because the row11 and 12 are merged in your format and this should not effect the output.
I hope this now makes more sense

please let me know if assistance required.

All comments

Raj

@PassION_es
the solution is feasible
as you are having a same format every time
first you can copy the format using blob tool for each different record
then once this is done use the output tool to specifically write the values in the cells

you will be required to change the date to 8 different columns to write the date

hope this helps
let me know if sample workflow required
mark done if solved.

PassION_es

Thanks for responding @Raj . However, I would need a sample of your workflow to have a better picture of your solution.

Assuming there are more than 10 rows, so the output should represent each row.

Raj

@PassION_es
you can find a sample how to achieve this
once you are satisfied with the solution, we can make changes to make this into a batch macro and this will be achieved/

hoping you are clear with blob logics so not used blob tool here

mark done if solved.

467.yxmd

PassION_es

i checked your workflow and it simpler than the blob tool. I noticed also that you use preserve formatting. Does the formatting remain the same even if it will output with a differnt filename for each row? like NAME1, NAME2, etc.?

Can you share me the whole workflow with a batch macro? Thanks so much.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703