topic My progress on fixed width in QlikView

My progress on fixed width

Wed, 25 Nov 2020 16:16:04 GMT

Hey community,

So is there anyone who can take this a bit further i have elaborated with fixedwidth generating csv files.

This is my result. Is is possible to make in a neater way? I want to easily make that on 78 columns in a certain value should be inserted for example. And the names to be left positioned always starting on column 20.

AND as a header in the CSV file i'd like to have the current date then all transactions.

Cheers it would be much, much apprecdiated!

Meddelandet redigerades av: Niklas Söderqvist

Re: My progress on fixed width

Mon, 12 Sep 2016 13:39:45 GMT

Made it somewhat more clear but still is there anyway of doing this more efficient?

Date as header problem remaining...

FFN:

LOAD

LEFT(ID,20) & Repeat(' ',20-len(ID))&

LEFT(Namn,25) & Repeat(' ',25-len(Namn))&

LEFT(Efternamn,20) & Repeat(' ',20-len(Efternamn))&

LEFT(Test,10) & Repeat(' ',10-len(Test))&

LEFT(Hej,18) & Repeat(' ',18-len(Hej))&

LEFT(Tecken,1) & Repeat(' ',1-len(Tecken)) as FixedForNiklas

;

LOAD ID,

Namn,

Efternamn,

Test,

Hej,

Tecken

FROM

(ooxml, embedded labels, table is Sheet1);

STORE * FROM FFN into C:\Users\niksod.NEONET\Desktop\Qlik\fixedwidthNiklas.csv (txt, delimiter is ','); LOAD ID,

Re: My progress on fixed width

stigchel — Mon, 12 Sep 2016 14:29:17 GMT

I would not use qlikview to generate fixed width files, why not do it straight from the source, excel in this case?

If you're determined, for the header you can use something like this :

LET vCurrDay = Left(Today(),10);

Header:

Load '$(vCurrDay)'&Repeat(Chr(32),10)&'Namn'&Repeat(Chr(32),16)&'Efternamn' as Final

AutoGenerate 1;

Concatenate Load

.........

rest of script