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

[PassION_es]

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.

[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.

[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.

[Raj · Accepted solution]

@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.

[PassION_es]

Thanks for clarifying, @Raj .

Alright got it. So I will be needing your workflow that includes the batch macro for data preparation and transformation, before integrating or writing it using the BLOB tool. 

Just need your assistance on how to produce the date from (From and To).  Let say, i have one column for a date of payment in the input file. Would you know how to set a condition that if the payment date of a certain row is 09/14/2024, then the period should fall in the 3rd quarter (July-September) of the year.  So the result will be:

FROM column: 07012024

TO column: 09302024

But if the other line item has 10/25/2024, then the "FROM" should be 10012024 and TO should be 12312024.