topic Re: Record display in Alteryx Designer Desktop Discussions

Record display

jmedidi — Tue, 25 Jan 2022 12:57:29 GMT

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

Re: Record display

MatthewO — Tue, 25 Jan 2022 13:11:04 GMT

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

Re: Record display

Thableaus — Tue, 25 Jan 2022 13:14:10 GMT

See flow attached.

Cheers,

Re: Record display

atcodedog05 — Tue, 25 Jan 2022 13:40:32 GMT

Hi @jmedidi

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

Workflow:

Hope this helps : )

Re: Record display

jmedidi — Tue, 25 Jan 2022 14:01:16 GMT

I have more than 4 columns

Re: Record display

messi007 — Tue, 25 Jan 2022 14:07:44 GMT

@jmedidi,

Please see below :

Attached the workflow,

Regards,

Re: Record display

jmedidi — Tue, 25 Jan 2022 18:54:57 GMT

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.

Re: Record display

gabrielvilella — Tue, 25 Jan 2022 21:05:18 GMT

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