How to put Dummy row in a loaded table

[#1]

Hi,

how can i add only one dummy row to a loaded csv.Table within the script ?

Here are my construct:

HEL_DATA:
LOAD

[Kunden ID] AS [HEL_DATA_Kunden ID],
[Werbetreibenden ID] AS [HEL_DATA_Werbetreibenden ID],
[Seiten ID] AS [HEL_DATA_Seiten ID]

FROM H:\Qlikview Workspace\APILoader\reports\28783*.csv (txt, codepage is 1252, embedded labels, delimiter is ';', msq);

I tried with this supplement. But when i run the script, i get syntetic keys !

HEL_DATA:
ADD LOAD * INLINE [
HEL_DATA_Kunden ID, HEL_DATA_Werbetreibenden ID, HEL_DATA_Seiten ID
jonny, 9001, 200
];

Thank you for your help.

Best regards

[hector · Accepted solution]

Hi, use concatenate

HEL_DATA:
LOAD
[Kunden ID] AS [HEL_DATA_Kunden ID],
[Werbetreibenden ID] AS [HEL_DATA_Werbetreibenden ID],
[Seiten ID] AS [HEL_DATA_Seiten ID]
FROM H:\Qlikview Workspace\APILoader\reports\28783*.csv (txt, codepage is 1252, embedded labels, delimiter is ';', msq);
Concatenate
LOAD * INLINE [
 HEL_DATA_Kunden ID, HEL_DATA_Werbetreibenden ID, HEL_DATA_Seiten ID
 jonny, 9001, 200
 ];

Rgds

[#3]

that's it !

Thank you !!

Best regards

[hector]

Ok, isn't mandatory the use of the reserved word concatenate, because both table are sharing the same quantity and names of the fields, so qlikview will auto-concatenate them

if you put just "concatenate" word, qlikview will concatenate the current table with the previous one (that's your case), but if you want to concatenate it with other table (maybe in another tab) use concatenate(table_name)

Rgds

[#5]

Thank you again