Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
hector
Specialist
Specialist

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
Specialist
Specialist

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
Author

that's it !

Thank you !!

Best regards

hector
Specialist
Specialist

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
Author

Thank you again Smile