123-45-6789=> Name,Name
How to get the result as SSN # Name
123-45-6789 Name,Name
@Yuvaraj85is your input data in the same row or multiple rows?
In 2 different rows in text file
@Yuvaraj85 one way of doing this with the help of cross tab
Thank you so much. But this is just a format. If you help me with any if condition formula then it will really helpful
Data123-45-6789 STATUS: TERM 30 LOCATION:=>Name,Name401K EE: 6,275.27ALLOC BEG BAL * * * * * * * * A C T I V I T Y * * * * * * * * END BALDESCRIPTION ID PCNT 2023/01/01 CONTRIB EARNINGS PAYMENTS LOANS OTHER 2023/06/06BAIRD CORE BD INV 02A 0.0% .11 .00 .29 .00 .00 .40-X .00BAIRD CORE BD INV 02D 0.0% .09 .00 .24 .00 .00 .33-X .00MFS INT INTRS VAL 0HA 10.0% 720.52 .00 79.06 .00 .00 795.61-M .00
Output need
Need to filter only -M from other column
@Yuvaraj85 One way of doing this, need to make some pattern before parsing in the description field ( the output of the description field will show _ instead of space, you can change that with the formula tool if you want)
How can we use the below formula in Alteryx=if(Mid(A1,4,1)="-"),Left(A1,11), "")
Thanks a lot for your help. But this will not work when the file is having multiple Participants and multiple funds
