topic Importing fixed width file with embedded labels in QlikView

Importing fixed width file with embedded labels

Mon, 07 Jun 2010 12:42:27 GMT

Hi everyone,

Any tips on importing fixed width files with embedded labels? I have a file like this and I'm seeing funny effects when I try to manipulate the fields. For example, I have :


Load @1:6,
 @7:7 as Sign,
 If(@7:7 = '-', 0 - @1:6, @1:6) as NewValue
FROM
C:\MyFile
(fix, codepage is 1252, embedded labels, header is 1 lines);

and I get the error message "Field names must be unique within table", but I am maintaining unique field names.

I'm wondering if it's best to avoid embedded lables and explicitly name each field. Any thoughts?

cheers

Tony

Importing fixed width file with embedded labels

Mon, 07 Jun 2010 13:32:11 GMT

hi tony,

you have renamed as @7:7 as sign and then u are using If(@7:7 = '-', 0 - @1:6, @1:6) as NewValue

this will not work because @7:7 has been renamed as sign and @7:7 no longer exists.if u use sign in place of @7:7 in your script ,that will also not work because sign is still being created in the script.

u can do a preceding load here

Load @1:6,If(Sign = '-', 0 - @1:6, @1:6) as NewValue;


Load @1:6,
 @7:7 as Sign,
FROM
C:\MyFile
(fix, codepage is 1252, embedded labels, header is 1 lines);

thanks

Importing fixed width file with embedded labels

Tue, 08 Jun 2010 09:36:32 GMT

Hi Tauqueer,

Thanks for the reply. It seems to me like it's to do with the embedded titles. I have re-written the script specifying the field names explicitly, and this seems to work:


Load @1:6 as Value,
 @7:7 as Sign,
 If(@7:7 = '-', 0 - @1:6, @1:6) as NewValue
 (fix, codepage is 1252, header is 2 lines);

Thanks for your help,

Tony