Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
1 Reply
petter
Partner - Champion III
Partner - Champion III

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;