topic Re: loading all values in text boxes in QlikView

loading all values in text boxes

alec1982 — Mon, 14 Dec 2015 15:57:29 GMT

hi,

I have a directory with 100 txt files and each file contain a connection string to a database.

I need a table with FileName and Content Value so each file will have one row in this table and it will have the file name and the connection string.

I got the file names into a a table using for function but not sure how I can handle the content and put them in one column..

Any idea?

Best,

Alec

Re: loading all values in text boxes

marcus_sommer — Mon, 14 Dec 2015 16:19:04 GMT

If the connection-string is already in one column respectively field you could load them directly:

Load filebasename() as FileName, ConStrField as ConnectionString From YourLoopVariable;

Is the string is parted into several fields you could concat them like: F1 & F2 & F3 as [F (all)]

- Marcus

Re: loading all values in text boxes

Peter_Cammaert — Mon, 14 Dec 2015 16:21:05 GMT

Treat every individual text file as a source table. The actual code depends on the format of the connection string file. However, imagine that it's a simple all-inclusive affair, then you can do as follows:

LET vRNum = 1;

For Each vFile in FileList(...) DO

TempTable:

LOAD [@1:n] AS CString FROM [$(vFile)](fix, unicode, record is 1 lines);

LET vConnString = peek('CString');

DROP Table TempTable;

FinalTable:

LOAD $(vRNum) AS ID,

'$(vFile)' AS FileName,

'$(vConnString)' AS [Content Value]

AUTOGENERATE 1;

LET vRNum = vRNum + 1;

Best,

Peter

Re: loading all values in text boxes

alec1982 — Mon, 14 Dec 2015 16:30:56 GMT

hi guys,

I got it to work by adding @1 as a field..

Thank you for your help!