Need some help to display the existing records as mentioned below: FilesCalibrationWarningsDV_Testing_completion_dateYes No n/a 06.00.05 033.44.33 112.3.45 Yes No n/a 12-Jun-20 8-Aug-20 21-Jan-22 Desired FilesCalibrationWarningsDV_Testing_completion_dateYes06.00.05Yes12-Jun-20No033.44.33No8-Aug-20n/a112.3.45n/a21-Jan-22

You can filter on one field that if that one is blank, you know that all the other are blank and should be removed. Or if you want to use the data cleansing too, you can have a multi field formula before like this: IF IsEmpty([_CurrentField_]) THEN Null() ELSE [_CurrentField_] ENDIF

@jmedidi, Please see below : Attached the workflow, Regards, Update_20220125.yxmd

Record display

jmedidi

Need some help to display the existing records as mentioned below:

Files	Calibration	Warnings	DV_Testing_completion_date
Yes
No
n/a
	06.00.05
	033.44.33
	112.3.45
		Yes
		No
		n/a
			12-Jun-20
			8-Aug-20
			21-Jan-22

Desired

Files	Calibration	Warnings	DV_Testing_completion_date
Yes	06.00.05	Yes	12-Jun-20
No	033.44.33	No	8-Aug-20
n/a	112.3.45	n/a	21-Jan-22

Developer Tools

Accepted answers

All comments

MatthewO

Hi @jmedidi - I believe the attached workflow will give you desired results.

removeNullRows.yxmd

Thableaus

See flow attached.

Cheers,

Format.yxmd

atcodedog05

Hi @jmedidi

My take on this works best if you have only 4 columns.

Workflow:

Hope this helps : )

get data.yxmd

jmedidi

Works well. But i see lot of blank rows below after the contents moved. I tried Data cleansing tool to remove Null rows but looks like it doesn't work to remove the blank rows. also i can also use filter to remove empty rows but there are more than 60 fields to work.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703