Evalute which fields are being used by which values

[ni_avoss]

Hi there,

for debug purposes I am trying to find a way to find all values which are in use for certain values, because I have a datamodel with a huge amount of fields.

The following example is probably more clear.

lets say this is the abstract structure:

Event	Field1	Field2	Field3	Field4
Event1	1	2
Event2			2
Event3		2		3
Event1				1

From this I would like to have a chart like this

Event	Fields in use
Event1	Field1
	Field2
	Field4
Event2	Field3
Event3	Field2
	Field4

I started and trying to build a calculated Dimension around $Field but so far I am not able to get this right. Is there another approach someone would like to share?

thanks a lot,

Alex

[agomes1971]

Hi,

have you checked this?

The Crosstable Load

HTH

André Gomes

[ni_avoss]

Hi there,

no - not yet I wasn't aware of this function which looks really useful to me.

However for my usecase it might be only a last possible option as I there is really a big amount of columns and those are also dynamic and changing,(each column is basically a JSON-property) so I would need to adjust the script when reloaded the data which I would prefer not to do. Also, I would like to do the analysis in chart and not via datamodel

anyway - thanks,

alex

[vishsaggi]

Try this provided if you have that data in any excel file just give that excel path.

CrossTable(Fields, Value)

LOAD Event,

     Field1,

     Field2,

     Field3,

     Field4

FROM

[..\Desktop\EgFile_2.xlsx]

(ooxml, embedded labels, table is Sheet1);

Create a straight table chart and use

Dim: Event, Fields

Expr: Value

Thanks,
V.