Need help in column formatiing

[Surajnair]

Hi All,

I need help in showing data in correct formatting in column wise format with no null rows.

When im taking union tool to merge both container data, second container data value is not coming in first row.

I need value to be shown from first row.

please help on this im attaching file and screenshot

[KGT · Accepted solution]

A union will not reduce the amount of rows. What you need here is a Join based on a trimmed version of your key columns to remove LDC-ORG and LDC-...

You could also sort your data correctly and then join based on row position.

[Surajnair]

Can you help me with prac solution

[Surajnair]

Hi @KGT,

Thank you for suggestion.

I have used record id for two containers and based on record I used join tool to make it in columnar format.

It worked thnx.