Discussion Board for collaboration on QlikView Scripting.
how to concatenate different sheets with different field names, see example below.
Item code, Description, Color, Price
Item Code, Size, Price
-Consider that this SHEET1 and SHEET2 is in one excel file.
Please help. Thanks.
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.
'sheet1' as Flag
'sheet2' as Flag
'Sheet1' AS SheetName
'Sheet2' AS SheetName
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.