Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

thierrytt
Contributor

Load multiple CrossTables with same structure

Hi all,

I've a problem regarding the loading of multiple crosstables.

I have 1 crosstable for 1 sheet.

These crosstable have the same structure. I already made a loop to load across different sheets but I have a problem.

For example:

Sheet1 = Mathematics

Name,  Surname, Name of Test1, Name of Test2, Name of Test3

Nick,Jonhson,12,13,11,

Ellen, Rob,18,19,10

Sheet2 = Language

Name,  Surname, Name of Test1, Name of Test2, Name of Test3, Name of Test 4,...

Nick,Jonhson,1,3,3,

Ellen, Rob,5,5,5

I have no problem to load the first crosstable (of the first sheet) but how can I automate the load of the cross table as the values of "Name of Test" are changing?

Can I have somethink like this?

CROSSTABLE (NameOfTheTest, Results, 2)

LOAD Name,

          FirstName,

          [Field 1],

          [Field 2]

          ...

FROM

Thank you for your help

1 Solution

Accepted Solutions
MVP
MVP

Re: Load multiple CrossTables with same structure

Hi,

Did you try

CROSSTABLE (NameOfTheTest, Results, 2)

LOAD *

FROM ...

If the first field is always the same, there shouldn't be any problem.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

2 Replies
chauhans85
Esteemed Contributor

Load multiple CrossTables with same structure

CROSSTABLE (NameOfTheTest, Results, 2)

LOAD Name,

          FirstName,

          [Field 1],

          [Field 2]

          ...

FROM     *.xls

MVP
MVP

Re: Load multiple CrossTables with same structure

Hi,

Did you try

CROSSTABLE (NameOfTheTest, Results, 2)

LOAD *

FROM ...

If the first field is always the same, there shouldn't be any problem.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Community Browser