Dynamic Field Names

[#1]

Hi...

I'm trying to load multiple Fields into one Flied:

For example:

LOAD

Icd+iterno() AS Icd

FROM .... WHILE iterno()<=30;

In this File are 30 Fields from "Icd1" to Icd30.

Is there any clue to solve that problem without using 30 JOIN LOAD of that Table?

Thanks!!!

[#2]

Hi,

If I understand the problem correctly, you want to take data for all 30 columns from source file and store into 1 column in qlikview. Below is a sample code for implementing this:

Tab1:
LOAD Icd1 AS Icd
FROM ....;

FOR a = 2 TO 30
CONCATENATE(Tab1)
LOAD Icd$(a) AS Icd
FROM ...;
NEXT

Hope this works..

Thanks

Amit

[#3]

Hello Olaf,

Not sure if I understand the question; could you explain what your input format is (I guess it's rows with columns ICD1 - ICD30) and what output format you want (rows with [ICD1, <value>], [ICD2, <value>], etc.? or perhaps all ICD-values concatenated as '<value>, <value>, <value>, ...' in one column?)

With regards,

Martijn ter Schegget

[johnw]

OK, so you have a table like this?

Icd1 Icd2 Icd3... Icd30
5 10 20 ... 50
3 2 1 ... 14

And you want to end up with a table like this?

Icd
5
10
20
...
50
3
2
1
...
14

If so, then I believe this would work:

CROSSTABLE (Sequence,Icd,0)
LOAD Icd1, Icd2, Icd3... Icd30
FROM your data source;
DROP FIELD Sequence;