Re: concatenate duplicate field. - Qlik Community

Anonymous · ‎2012-06-20

Does anyone know how to do this?

I need to group the repeated line as shown below.

to

LOAD

* INLINE [
FORNECEDOR, GRUPO, PRODUTO, VEICULO
320, 310, 11, FIAT
320, 310, 11, CHEVR
320, 310, 13, FORD
]

;

Report Inappropriate Content · ‎2012-06-20

Hi,

you can create a straight table with dimension "Fornecedor", "Grupo" and "Produto"

create a expression:

CONCAT(VEICULO, ',');

Anonymous · ‎2012-06-20

Is there any way to do this function within the scipt?

Report Inappropriate Content · ‎2012-06-20

LOAD

FORNECEDOR,

GRUPO,

PRODUTO,

CONCAT(VEICULO, ',') AS VEIC

INLINE [

FORNECEDOR, GRUPO, PRODUTO, VEICULO

320, 310, 11, FIAT

320, 310, 11, CHEVR

320, 310, 13, FORD

]

GROUP BY FORNECEDOR,

GRUPO,

PRODUTO;

Anonymous · ‎2012-06-20

Beauty, solved the problem, thanks.

Jason_Michaelides · ‎2012-06-20

Please make sure you mark a correct answer so it closes the thread.

Thanks,

Jason