How to count bits or bytes of source text file characters

[Anonymous]

Hi friends can anyone help on How to validate Errors in QlikView My case we will get .txt file as source while loading we need to validate the bit count for each row.

Eg:Our case we get Source .txt file without any comma or column name based on standard mapping doucument need to find column dimensions and measures.

1. 00102014060102050002100B10500171200000è38 bits

001-Office(3 bits),

0201406-Period(7 bits)

01020500021-Ship Id(11 bits)

00B105-Code(6 bits)

001-Currency(3 bits)

71200000-Amount(8 bits)

My main Requirement solution I need is always to check record bits size whether it is same or else corrupted with spaces or special characters

  Is it possible to validate null or blank spaces in key columns

[saumyashah90]

To count no. of rows add one more column RecNo()

like

load * ,

RowNo() as Rows from XYZ;

Max(Rows) will show you total number of rows

[saumyashah90]

This may help you

[Anonymous]

Thanx for solution but neet to know bits for attached code as based on Bits precession Facts or Dimensions names are given.

[Anonymous]

please can any one  help on this Issue attached Qvw.