Meta data about concatenated facts

[pernillet]

Is there any system function or simular, that can show which fields are in a concatenated fact and from which origin/table they come from ?

Like this:

Table1:

Load

A,

B,

C,

"1" as Factname

From xx1;

Concatenate (Table1)

Load

A,

B,

D,

"2" as Factname

From xx2;

Concatinate (Table1)

Load

A,

B,

E,

"3" as Factname

From xx2;

　

I would like the result:

Field:　　　　　　　　　　　　 Factname

A　　　　　　　　　　　　　　　　　　　　　　　　　 1,2,3

B　　　　　　　　　　　　　　　　　　　　　　　　　 1,2,3

C　　　　　　　　　　　　　　　　　　　　　　　　　 1

D　　　　　　　　　　　　　　　　　　　　　　　　　 2

E　　　　　　　　　　　　　　　　　　　　　　　　　　3

[rubenmarin]

Hi, I think there is no built-in possibility, you need to add an 'origin', 'source', 'factname' or similar field to keep the trace of where the values are coming.

[Brett_Bleess]

Have a couple of things, but not sure they are going to be of much help:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Table-Viewer/ba-p/1474304

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/System_fields.h...

That is about it in the way of additional info of which I can think.

Regards,
Brett