Discussion Board for collaboration related to QlikView App Development.
hi i have the following question.
i wish to avoid the following scenario by setting the length of my fields to 6 and 3 accordingly and filling the blank values with 0.
is this possible?
you say you want length of 6 and 3 but your desired result is diffferent
load OrderNo, text(RowNo) as RowNo;
LOAD * INLINE [
repeat('0', 6 - len(OrderNo)) & OrderNo as OrderNo,
repeat('0', 3 - len(RowNo)) & RowNo as RowNo,
autonumber(OrderNo & RowNo) as %Key
drop table Inline;
RESULT (lOrderNo ength 6, RowNo length 3)
View solution in original post