topic Re: Add a null field to column is one is not present in QlikView

Add a null field to column is one is not present

Nitaci — Mon, 28 Nov 2022 09:51:45 GMT

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?

Re: Add a null field to column is one is not present

Or — Mon, 28 Nov 2022 09:55:22 GMT

Table:

Load Name1,

Name2,

from qvd_file;

Concatenate

Load Distinct Name1

Resident Table;

Re: Add a null field to column is one is not present

Nitaci — Mon, 28 Nov 2022 11:54:21 GMT

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?

Re: Add a null field to column is one is not present

Bill_Britt — Mon, 28 Nov 2022 12:06:10 GMT

Hi,

Look at using a mapping load.

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