Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Data Loading

Please help me to how load this file cross loading

 

DirectDirectDirectDirectDirectDirectDirectDirectDirectDirect
CC Total w IR to ER AdjCC Total w IR to ER AdjCC Total w IR to ER AdjCC Total w IR to ER AdjCC Total w IR to ER AdjCC Total w IR to ER AdjCC Total w IR to ER AdjCC Total w IR to ER AdjCC Total w IR to ER AdjCC Total w IR to ER Adj
PRODPRODPRODPRODPRODPRODPRODPRODPRODPROD
No Trading PartnerTotal Trading PartnerNo Trading PartnerTotal Trading PartnerNo Trading PartnerTotal Trading PartnerNo Trading PartnerTotal Trading PartnerNo Trading PartnerTotal Trading Partner
ActualActualBudgetBudgetO6O6O10O10ActualActual
FinalFinalFinalFinalFinalFinalFinalFinalFinalFinal
2017201720172017201720172017201720172017
OctOctNovNovNovNovNovNovNovNov
USD_RPTUSD_RPTUSD_RPTUSD_RPTUSD_RPTUSD_RPTUSD_RPTUSD_RPTUSD_RPTUSD_RPT
Customer NameProfit CenterRevenueR61000RevenueR61000RevenueR61000RevenueR61000RevenueR61000
BANCO MONEX, S.A_MSxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
BANCO MONEX, S.A_SIxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
BANCO MONEX, S.A_BDxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
BANCO MONEX, S.A_CSxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Deutsche Bank_MSxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Deutsche Bank_SIxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Deutsche Bank_BDxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Deutsche Bank_CSxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
DTCC_MSxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
DTCC_SIxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
DTCC_BDxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
DTCC_CSxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Eaton Vance corp_MSxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Eaton Vance corp_SIxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Eaton Vance corp_BDxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Eaton Vance corp_CSxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
FEDERATED INVESTORS_MSxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
FEDERATED INVESTORS_SIxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
FEDERATED INVESTORS_BDxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
FEDERATED INVESTORS_CSxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Franklin Templeton_MSxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Franklin Templeton_SIxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Franklin Templeton_BDxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Franklin Templeton_CSxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Tags (1)
1 Reply
Highlighted
MVP
MVP

Re: Data Loading

By doing two loads you can keep the label lines in a separate but connected reference table. Then you can do a CrossLoad:

LABELS:

LOAD

'@' & (RowNo()+2) AS D#,*;

LOAD @1 AS D1,

     @2 AS D2,

     @3 AS D3,

     @4 AS D4,

     @5 AS D5,

     @6 AS D6,

     @7 AS D7,

     @8 AS D8,

     @9 AS D9,

     @10 AS D10

FROM

[CrossTable.tsv]

(txt, codepage is 1252, no labels, delimiter is '\t', msq, filters(

Remove(Row, RowCnd(Interval, Pos(Top, 11), Pos(Bottom, 1), Select(1, 0))),

Rotate(left)

));


DATA:

CrossTable(D#, Data, 2)

LOAD * FROM

[CrossTable.tsv]

(txt, codepage is 1252, no labels, delimiter is '\t', msq, header is 10 lines);

RENAME FIELDS @1 TO NAME, @2 TO CODE;