Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Morning,
I have a spreadsheet in excell containing some columns in horinzontal and need her fiquel upright columns months and values are the same in green and blue. someone would have an idea of how to do?
I am sending attached.
You could transform your horizontal columns per The Crosstable Load into a normal table-structure and a match between the string monthnames to the numeric monthnumbers could be done per Mapping … and not the geographical kind.
- Marcus
Hi Oliveira,
your excel file is kind of a cross table. With the below script you can load this file easily:
CrossTable(Mes, Value, 16)
LOAD [Código do Sistema],
[Tipo de Movimento],
[Ano do Orçamento],
[Mês do Orçamento],
[Código da Empresa],
[Código da Unidade],
[Código do Centro],
[Código Conta Orçamentária],
[Quantidade do Movimento],
[Valor do Movimento],
[Valor Fixo],
[Nome do Arquivo],
[Ano do Plano],
[Código Conta Contábil],
[Código de Entrada],
Data,
Janeiro,
Fevereiro,
Março,
Abril,
Maio,
Junho,
Julho,
Agosto,
Setembro,
Outubro,
Novembro,
Dezembro
FROM
Base_Excell.xlsx
(ooxml, embedded labels, table is Plan1, filters(
ColXtr(11, RowCnd(Every), 0),
ColXtr(12, RowCnd(Every), 0),
ColXtr(13, RowCnd(Every), 0),
ColXtr(14, RowCnd(Every), 0),
ColXtr(15, RowCnd(Every), 0),
ColXtr(16, RowCnd(Every), 0),
ColXtr(17, RowCnd(Every), 0),
ColXtr(18, RowCnd(Every), 0),
ColXtr(19, RowCnd(Every), 0),
ColXtr(20, RowCnd(Every), 0),
ColXtr(21, RowCnd(Every), 0),
ColXtr(22, RowCnd(Every), 0),
Remove(Col, Pos(Top, 22)),
Remove(Col, Pos(Top, 21)),
Remove(Col, Pos(Top, 20)),
Remove(Col, Pos(Top, 19)),
Remove(Col, Pos(Top, 18)),
Remove(Col, Pos(Top, 17)),
Remove(Col, Pos(Top, 16)),
Remove(Col, Pos(Top, 15)),
Remove(Col, Pos(Top, 14)),
Remove(Col, Pos(Top, 13)),
Remove(Col, Pos(Top, 12)),
Remove(Col, Pos(Top, 11))
));
Hope this helps.
Burkhard
thank you
