cancel
Showing results for 
Search instead for 
Did you mean: 

how to bring a concatenation from query to query

idor_001
Explorer
0 Kudos

hello all,

I have two queries that merge on the same key (item)

in the report

in one query I create a concatenation of all types foreach item.

I would like to bring that result to my other query

(only in the report level no idt)

I create those var in query 1:

var1= type + ','+ previous(self;(item)) -- dim

var2= last(type) in( item) -- measure

var3= var1 where(item=var2) -- measure

i created the report based on query 2 and when i bring var3 that i created to the report

I'm getting datasync error or blank

could someone pour some light on this issue

appreciate !

Accepted Solutions (0)

Answers (0)