Fix a Data Spill

[Inactive User]

Hi, can someone help me to fixed the data spill? I have attached the sample input and output

[Nuno_Meneses]

@Inactive User  could you elaborate your question?

[Inactive User]

I would like to realign the data based on the sample input and output in the attached file

[Nuno_Meneses]

Do you mean adjust the columns width?

[Inactive User]

No as you can see there are certain values that moved to another row. I would like to realign it based on the column header names. The expected output is in the attached file

 

 

[Nuno_Meneses]

What is causing this in your workflow? Can you provide a sample of your workflow?

 

[Inactive User]

No, the issue is the data provided to me and not the workflow. I am trying to see if anyone could help to develop a workflow that could fix the data issue in the attached file

[caltang]

This can be fixed, but I'll need more details first:

What is the significance of 41916? Is it date converted to numeric? Or what?

In addition, can you give more data? Show more examples, see how different the data gets. This helps make the solution more dynamic and solid.

[Inactive User]

For 41916, that is a numeric field. Unfortunately, that is the only data that I had with data spill

[caltang]

If it's one off, then I think you can adjust it on your own. Are you looking to make it dynamic for future scenarios?