Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
| ID | Value |
| 1 | A |
| 2 | B |
| 3 | C |
| 4 | D |
| 5 |
Thank you very much for any suggestions!
@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:
@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:
Brilliant! Thank you so much!