Adding data to empty rows from above record.

[Alteryx_user_aK]

Hi,

I am getting a source file in below format

2023 | New York |M |2344.56|01012023
         |                 |G |343.56|01012023
         |                 |P |23474.56|01012023
         |                 |A |1000|01012023
         | Chicago   |B |2344.56|01012023
         |                 |   |888.34|02012023
         |                 |C |2345.56|02012023

But I want to generate output as per below 

2023 | New York |M |2344.56|01012023
2023 | New York |G |343.56|01012023
2023 | New York |P |23474.56|01012023
2023 | New York |A |1000|01012023
2023 | Chicago |B |2344.56|01012023
2023 | Chicago |B |888.34|02012023
2023 | Chicago |C |2345.56|02012023

How to achieve it ?

Thanks in advanced.

AK

[ShankerV]

Hi @Alteryx_user_aK 

This can be achieved with the help of Text to columns tool using Pipe delimiter.

Then use Muti Row formula to achieve the output.

[ShankerV · Accepted solution]

Hi @Alteryx_user_aK 

A sample use case below for your scenario.

Many thanks

Shanker V

[binuacs · Accepted solution]

@Alteryx_user_aK One way of doing thi

[Alteryx_user_aK]

I have downloaded and tested the solution. Both are working as expected. I go with first solution. 

thank you Shanker and binuacs. appreciated your help.

[Alteryx_user_aK]

Thanks for your support

[Alteryx_user_aK]

Thanks you Shanker