Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Nitaci
Contributor II
Contributor II

Add a null field to column is one is not present

Hello I have a datastructure that looks like 

+--------+-------+
| Name1 | Name2 |
+--------+-------+
| A | A1 |
+--------+-------+
| A | A2 |
+--------+-------+
| B | - |
+--------+-------+
| B | B1 |
+--------+-------+
| B | B2 |
+--------+-------+

Now this is loaded from a .qvd file. Thourgh standart load

Load Name1,

           Name2,

from qvd_file

I want to make it so, that each cell in Name1 has atleast one empy ('-') value in Name2, that is I want to transform this table to 

 

+--------+-------+
| Name1 | Name2 |

+--------+-------+
| A | - |                                                           (Change here)
+--------+-------+
| A | A1 |
+--------+-------+
| A | A2 |
+--------+-------+
| B | - |
+--------+-------+
| B | B1 |
+--------+-------+
| B | B2 |
+--------+-------+

 

Now this is done over a large file so I can't do it manually... Any tips?

Labels (1)
3 Replies
Or
MVP
MVP

Table:

Load Name1,

Name2,

from qvd_file;

Concatenate

Load Distinct Name1

Resident Table;

Nitaci
Contributor II
Contributor II
Author

Thank you for the reply. For some reason this doesn't work for me, that may be because the table I showed is a part of a more complicated data structure.... Any other suggestions?

Bill_Britt
Former Employee
Former Employee

Hi,

Look at using a mapping load.

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptP...

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.