topic concatenate different (excel) in QlikView

concatenate different (excel)

Fri, 13 Apr 2012 05:26:29 GMT

Hi,

how to concatenate different sheets with different field names, see example below.

SHEET1

Item code, Description, Color, Price

SHEET2

Item Code, Size, Price

-Consider that this SHEET1 and SHEET2 is in one excel file.

Please help. Thanks.

Best Regards,

Bill

concatenate different (excel)

Fri, 13 Apr 2012 05:45:49 GMT

Hi brillringer,

ok you have two diffrent sheets of excel and you want to concatenate two tables

which are having almost same fields, In qlik view you can do something like this.

Tablename:

load

Item code,

Description,

Color,

Price,

'sheet1' as Flag

from sheet1.xls;

concatenate

load

Item code,

Description,

Color,

Price,

'sheet2' as Flag

from sheet2.xls;

Thanks

Anant Dubey

concatenate different (excel)

jagan — Fri, 13 Apr 2012 06:11:31 GMT

Hi,

Try this,

TableName:

LOAD

Item code,

Description,

Color,

Price,

'Sheet1' AS SheetName

FROM ExcelFile;

CONCATENATE

LOAD

[Item Code],

Size,

Price,

'Sheet2' AS SheetName

FROM ExcelFile;

Regards,

Jagan.

Re: concatenate different (excel)

Fri, 13 Apr 2012 07:01:27 GMT

Actually, the number of sheets is indefinite (no exact number of sheets) so scripting should be dynamic. It could be 2 sheets or 5 sheets or 10 sheets.

Thanks.