How to remove null value from the columns.

[Mohd-Siddiqui1]

Hi there,

Could you please help me with the below stated query.

I have provided the input data and I want the output as shown in Output Data table.

Input Data:

Column1	Column2
ABC	[Null]
DEFG	[Null]
HIJKLM	[Null]
1234	[Null]
10abcde	[Null]
[Null]	PQrstu
[Null]	9xyz

Output Data:

Column1	Column2
ABC	PQrstu
DEFG	9xyz
HIJKLM
1234
10abcde

[atcodedog05]

Hi @Mohd-Siddiqui1 

You a data cleanse tool on columns and make sure below-highlighted options are selected.

Or use Multi-Field formula on the columns

Hope this helps : )

[Mohd-Siddiqui1]

Hi atcodedog05,

Thanks for the reply.

The input data for the Column2 starts at the 6th row and all are [Null] values till row 5 in Column2. I think your input data for Column2 starting from 1st row only.

I have previously used Data Cleansing Tool to remove [Null] values and it was working successfully, but it is the placement of Data in Column2 which is creating a problem for me.

Could you please look into this.

[atcodedog05]

Hi @Mohd-Siddiqui1 

Oops sorry my bad here is the updated workflow

Hope this helps : )

[Mohd-Siddiqui1]

Hi @atcodedog05 

I think the input is again not correct.

Could you please use below input.

Column1	Column2
ABC	[Null]
DEFG	[Null]
HIJKLM	[Null]
1234	[Null]
10abcde	[Null]
[Null]	PQrstu
[Null]	9xyz

Output Data:

Column1	Column2
ABC	PQrstu
DEFG	9xyz
HIJKLM
1234
10abcde

[atcodedog05 · Accepted solution]

Hi @Mohd-Siddiqui1 

Sorry my bad again. Got bit confused

Input:

Output:

Hope this helps : )

[Mohd-Siddiqui1]

Hi @atcodedog05 

Thank you for your quick responses and help 🙂

[binu_acs]

@Mohd-Siddiqui1 another method using join tool

[atcodedog05]

Happy to help : ) @Mohd-Siddiqui1 

Cheers and have a nice day!