Remove Null Values from Output, but keep all other values from Record/Row

[HenpetsGordres1]

RE: Find End Date and set for all related records 

Following on from my previous 2 questions, I wanted to check if the following is possible. I have created an output similar to the below image:

My final output will be in XML format, is it possible to drop the 'Non UK' column for the first 2 records? So in theory the 2nd and 3rd records would appear something like the below image (i.e. Row 12: NonUK is only present when not null):

I have been able to program the XML output but can't remove 'NonUK' from Row 2. Is it possible to remove this before output so my file does not appear like the below:

Many thanks

[afv2688]

Hello @HenpetsGordres1 ,

You can definitely do that.

Open your report on the alteryx designer as a csv with the delimieter \0

After that you could just insert a filter tool with the 'Does not equal' and <NonUK>.

This would delete the empty <NonUK> from your file

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

[OllieClarke · Accepted solution]

Depending on how you're creating your xml in the workflow @HenpetsGordres1 you could use the following formula immediately before the output tool

REPLACE([XML],'<NonUK>[Null]</NonUK>','')

edit: added screenshot

[HenpetsGordres1]

Thank you both for your proposed solutions. I chose to use Ollie's as the 'NonUK' field was created within the workflow so the REPLACE Formula was an easier approach, while I'm sure both are great solutions. Many thanks to all involved.