Add a null field to column is one is not present

[Nitaci]

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?

[Or]

Table:

Load Name1,

Name2,

from qvd_file;

Concatenate

Load Distinct Name1

Resident Table;

[Nitaci]

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]

Hi,

Look at using a mapping load.

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