Data Shifted to next column

Question

Hi I am currently facing data shifting issue. There is one column that I just want to move it according to its right position. I just want to fix it

From this:

F1DocNoDocdatePostdateCodeNameTypeAmountSGAsgText100814315910/19/202010/20/2020500010Utilization ExpenseK1600 166448501-PF1DR-9307-10-19-20  100814316110/19/202010/20/2020500010Utilization ExpenseK1600 166531346-PF1DR-9307-10-19-20

To this:

F1DocNoDocdatePostdateCodeNameTypeAmountSGAsgText 100814315910/19/202010/20/2020500010Utilization ExpenseK1600 166448501-PF1DR-9307-10-19-20 100814316110/19/202010/20/2020500010Utilization ExpenseK1600 166531346-PF1DR-9307-10-19-20

Could you help me with this one pls?

danilang · Answer

Hi @enkenmendoza

How do you know which rows need to be adjusted? Is it always the ones that have a value in F1?

Dan

AngelosPachis · Answer

Hi @enkenmendoza ,

The slightly painful way to do that is through a union tool. You can split out groups of records that have been moved by one column to the right/left and then bring them together with a union tool.

The union tool will allow you to manually configure which fields are stacked together.

Hope that helps,

Angelos

example.yxmd