topic Re: Adding rows based on cell value in App Development

Adding rows based on cell value

Frank_Hartmann — Tue, 05 Mar 2024 11:40:38 GMT

Hi folks,

I have this table:

and i need to get an extra row above each header cell:

LOAD * INLINE [
dim1, dim2, dim3
1, 0x3B1B, header
2, n/a, parameter
3, n/a, value
4, n/a, parameter
5, n/a, value
6, 0x3B1F, header
7, n/a, parameter
8, n/a, value
9, 0x21DE, header
10, n/a, parameter
11, n/a, value
];

Any ideas how to achieve that?

Re: Adding rows based on cell value

LRuCelver — Tue, 05 Mar 2024 12:04:09 GMT

Data: NoConcatenate Load * Inline [ dim1, dim2, dim3 1, 0x3B1B, header 2, n/a, parameter 3, n/a, value 4, n/a, parameter 5, n/a, value 6, 0x3B1F, header 7, n/a, parameter 8, n/a, value 9, 0x21DE, header 10, n/a, parameter 11, n/a, value ]; Concatenate(Data) Load dim1 - 0.5 as dim1, 'Your dim2 here' as dim2, 'Your dim3 here' as dim3 Resident Data Where dim3 = 'header';