topic Re: Read header in QlikView

Read header

pgalvezt — Wed, 06 Apr 2016 17:14:53 GMT

Hi,

Actually I have had reading multiples xls from 1 folder.

Problem is four of the all headers are 1 row upper in excel and in their place there are numbers. Those numbers goes changing according to excel file. I Ittached an enviroment excel file explaining the situation. How qlikview can read this?

Thanks!

Re: Read header

HirisH_V7 — Wed, 06 Apr 2016 17:54:59 GMT

Hi,

May be like this,

Data:
LOAD Name,
     Number,
     Account,
     ID,
     Sale,
     Sale%,
     [Header a],
     [Header b],
     [Header c],
     [Header d]
FROM
[ColumnHeaderProblem*.xlsx]
(ooxml, embedded labels, table is [What I Have], filters(
Replace(1, bottom, StrCnd(null)),
Replace(2, bottom, StrCnd(null)),
Replace(3, bottom, StrCnd(null)),
Replace(4, bottom, StrCnd(null)),
Replace(1, bottom, StrCnd(null)),
Replace(5, bottom, StrCnd(null)),
Replace(6, bottom, StrCnd(null)),
Remove(Row, Pos(Top, 2))
));

Table:

Hope this helps,

PFA,

Hirish

Re: Read header

pgalvezt — Wed, 06 Apr 2016 18:40:32 GMT

Hi, Thank you for your reply,

Question? Did you use a table qlikview assistance? (Transform)?

Re: Read header

pgalvezt — Wed, 06 Apr 2016 19:39:29 GMT

I try with code, and I try wih table assistance (Here I think you did something)... I don´t know what thing is...

I attach my test sample with base data... Is the same to the real in format.

Re: Read header

pgalvezt — Wed, 06 Apr 2016 21:11:18 GMT

Here is the solution, In label I Changed all names and then delete the 2nd row. Now QlikView read all field documents very well...

(biff, embedded labels, table is GENERAL$, filters(

Remove(Row, Pos(Top, 5)),

Remove(Row, Pos(Top, 4)),

Remove(Row, Pos(Top, 3)),

Remove(Row, Pos(Top, 2)),

Remove(Row, Pos(Top, 1)),

Top(1, 'Rut'),

Top(2, 'Nombre'),

Top(3, 'H. Pactadas'),

Top(4, 'Lunes'),

Top(5, 'Martes'),

Top(6, 'Miercoles'),

Top(7, 'Jueves'),

Top(8, 'Viernes'),

Top(9, 'Sabado'),

Top(10, 'Domingo'),

Top(11, 'Semanales'),

Top(12, 'Ordinarias'),

Top(13, 'H. Extras'),

Top(14, 'D. Trabajados'),

Top(15, 'Locomocion'),

Top(20, 'Errores'),

Top(21, 'Entero'),

Top(22, 'Hora'),

Top(23, 'Status'),

Top(24, 'CeCo'),

Top(25, 'Cod. CeCo'),

Top(26, 'Sueldo'),

Top(27, 'Nomina'),

Top(28, 'Cargo'),

Top(29, 'xx'),

Remove(Row, Pos(Top, 2))

));

Re: Read header

HirisH_V7 — Thu, 07 Apr 2016 03:48:48 GMT

Yup I used qlikview transform.

Fine your Query Solved.

-Hirish