Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
ZuzJsk007
Contributor III
Contributor III

insert one blank row to table in script

Hi folks, I'm fairly new to Qlik Sense and I would really appreciate help with following issue:

Let's image I have a table in my load script

Table:

LOAD * INLINE [

ID, Value   

1, A

2, B

3, C

4, D

];

I want to add a new blank row automaticly with ID = max(ID) + 1 BUT I want to secure that with every load, there's only one blank row (if I reload data 5 times there always be only 1 new blank row with ID = max(ID) +1) so the table would look like

Table:

IDValue
1A
2B
3C
4D
5 

 

Thank you very much for any suggestions!

Labels (1)
1 Solution

Accepted Solutions
Taoufiq_Zarra

@ZuzJsk007  like ?

Data:

LOAD * INLINE [

ID, Value   

1, A

2, B

3, C

4, D

];
concatenate

load Max(ID)+1 as ID,'' as Value resident Data;

 

output:

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

2 Replies
Taoufiq_Zarra

@ZuzJsk007  like ?

Data:

LOAD * INLINE [

ID, Value   

1, A

2, B

3, C

4, D

];
concatenate

load Max(ID)+1 as ID,'' as Value resident Data;

 

output:

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
ZuzJsk007
Contributor III
Contributor III
Author

Brilliant! Thank you so much!