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

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

LocationID.xlsx

Developer

Output

Accepted answers

OllieClarke

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

All comments

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

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.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335