Wildmatch over multiple fields

[Karl_Hart]

I have the following expression in a text box.

=sum([NS D1 Desk])

+sum([NS D1 Facilities])

+sum([NS D1 Hours])

+sum([NS D1 HRBP])

+sum([NS D1 Induction])

+sum([NS D1 Inductionmeeting])

+sum([NS D1 Introduced])

+sum([NS D1 Login])

+sum([NS D1 ManualHandling])

+sum([NS D1 Officetour])

+sum([NS D1 Password])

+sum([NS D1 Reception])

+sum([NS D1 Uniform])

Is there a way to use a wildcard to have it something like

=sum([NS D1 *])

For reference, the data looks something like

Name          ND D1 Desk     NS D1 Facilities     NS D1 Hours .........

Adam               1                         0                              1

Betty                1                         1                              0   

Carl                  1                         1                              1                   

Denise              0                         0                              1

:

:

So the answer in this made up example would be sum([NS D1 *]) = 8

Thanks,

Karl

[sunny_talwar]

So, I tried this

Table:

LOAD * INLINE [

    Dim, 2016, 2017

    A, 20, 40

    B, 30, 65

];

STORE Table into Table.qvd (qvd);

DROP Table Table;

Table:

CrossTable(Year, Value)

LOAD *

FROM Table.qvd (qvd);

Gave me this

While this worked without any issues

Table:

LOAD * INLINE [

    Dim, 2016, 2017

    A, 20, 40

    B, 30, 65

];

STORE Table into Table.qvd (qvd);

DROP Table Table;

Table:

CrossTable(Year, Value)

LOAD *

FROM Table.qvd (qvd)

Where 1 = 1;

[Peter_Cammaert]

Yeah, orphans all over the place. You really don't want that in your data model.

Still the same as it used to be.

[Karl_Hart]

Thank you, this worked perfectly