Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

How to put Dummy row in a loaded table

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

Tags (1)
1 Solution

Accepted Solutions
hector
Valued Contributor

Add a row in a loaded table

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

View solution in original post

4 Replies
hector
Valued Contributor

Add a row in a loaded table

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

View solution in original post

Not applicable

Add a row in a loaded table

that's it !

Thank you !!

Best regards

hector
Valued Contributor

Add a row in a loaded table

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

Not applicable

Add a row in a loaded table

Thank you again Smile