Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

washington
Contributor

concatenate duplicate field.

Does anyone know how to do this?

I need to group the repeated line as shown below.

FORNECEDORGRUPOPRODUTOVEICULO
32031011CHEVR
32031011FIAT
32031013FORD

to

FORNECEDORGRUPOPRODUTOVEICULO
32031011CHEVR, FIAT
32031013FORD

 

LOAD

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

;

5 Replies
Not applicable

Re: concatenate duplicate field.

Hi,

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

create a expression:

CONCAT(VEICULO, ',');

washington
Contributor

Re: concatenate duplicate field.

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

Not applicable

Re: concatenate duplicate field.

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;

washington
Contributor

Re: concatenate duplicate field.

Beauty, solved the problem, thanks.

jason_michaelid
Honored Contributor II

Re: concatenate duplicate field.

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

Thanks,

Jason

Community Browser