Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
svickery
Contributor
Contributor

How do I resequence my load file?

currently loading

LOAD @1 as QN_Age,
@2 as QN_Notification,
@3 as QN_RejectQty,
@4 as QN_MaterialNo,
@5 as QN_StandardPrice,
@6 as QN_MaterialGRoup,
@7 as QN_SupplierNo,
@8 as QN_SupplierName,
@9 as EKGRP,
@10 as QN_Value,
@11 as QN_Responsibility,
@12 as QN_DiscpcyShortTxt,
@13 as QN_LongTxt
FROM

would prefer it to load like this

LOAD @9 as EKGRP,
@1 as QN_Age,
@2 as QN_Notification,
@3 as QN_RejectQty,
@4 as QN_MaterialNo,
@5 as QN_StandardPrice,
@6 as QN_MaterialGRoup,
@7 as QN_SupplierNo,
@8 as QN_SupplierName,
@10 as QN_Value,
@11 as QN_Responsibility,
@12 as QN_DiscpcyShortTxt,
@13 as QN_LongTxt
FROM

0 Replies