topic Combile multiple rows in one row data in QlikView

Combile multiple rows in one row data

DipeshVadgama — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a raw data which is been spited by its item ID, Customer name, Country, etc.

Example if any cell row have: India, USA, Africa

This country is spited in different rows:

India

USA

Africa

I would like to merge all this multiple entries in to single row. Please find attached file with 2 sheets.

Anil_Babu_Samineni — Wed, 17 Jan 2018 11:21:13 GMT

There is no Cell row for all Strings which you want to split in sample?

sunny_talwar — Wed, 17 Jan 2018 12:15:47 GMT

Try this

Table:

LOAD [Item ID],

Concat([Customer Name], ', ') as [Customer Name],

Concat(Counry, ', ') as Counry,

Package,

Concat([Item Number], ', ') as [Item Number],

[PASS/FAIL]

FROM

[..\..\Downloads\Qlik_Question.xlsx]

(ooxml, embedded labels, table is [Raw Data])

Group By [Item ID], Package, [PASS/FAIL];