Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

removing blank columns from a row

I want to remove blank columns from a row, how is this possbile?
so lets say my row coming in from an xml file looks like this:
<row>
<name>tom</name>
<age>24 </age>
<sex/>
</row>
i read it in and i want to remove the sex column as its blank. how can this be done so that my ouput to an xml file looks like this:
<name>tom</name>
<age>24</age>
Labels (3)
4 Replies
Anonymous
Not applicable

Hello
There is an otpion 'Create empty element if needed' on advanced settings panel of tAdvancedFileOutputXML, uncheck this option to remove the empty element.
Best regards

shong
0683p000009MChT.png
_AnonymousUser
Specialist III
Specialist III
Author

Hi,
I did that and its unchecked on another job I have and it doesnt work, it still prints out the element like this:
<cameraType></cameraType>
<ParentList/>
Anonymous
Not applicable

How to remove the blank tag from the XML?
I have unchecked the checkbox which was present in the settings of tAdvanceOutputXml i,e; create empty element if needed. But still empty tag is occuring.
One thing i noticed that the tag which appeared <ParentList/> in this format works fine after unchecking the text box but the tag which is like <ParentList></ParentList> still comes.
Please guide how to handle this.
Anonymous
Not applicable

Hello
One thing i noticed that the tag which appeared <ParentList/> in this format works fine after unchecking the text box but the tag which is like <ParentList></ParentList> still comes.

I tested and found that this option is invalid now. Please report a bug on our bugtracker.
Thanks for your support!!!
Best regards

shong