topic Re: Creating one field from multiple fields in a load script in QlikView

Creating one field from multiple fields in a load script

Thu, 24 Sep 2015 07:20:22 GMT

I Have the following fields in my load script

LOAD

ZZMLST_ZAEHL1

,
ZZMLST_ZAEHL2

,
ZZMLST_ZAEHL3

,
ZZMLST_ZAEHL4

,
ZZMLST_ZAEHL5

I want to create one field from them called Milestone that I can use in my dashboard

Re: Creating one field from multiple fields in a load script

Digvijay_Singh — Thu, 24 Sep 2015 07:51:29 GMT

It depends how do you want to build that field, it could be like -

ZZMLST_ZAEHL1 & '-' & ZZMLST_ZAEHL2 &...... as Milestone

Re: Creating one field from multiple fields in a load script

alexandros17 — Thu, 24 Sep 2015 07:56:54 GMT

LOAD ZMLST_ZAEHL1 & ZZMLST_ZAEHL2 & ..... as Milestone Resident ....

Re: Creating one field from multiple fields in a load script

Thu, 24 Sep 2015 07:57:43 GMT

Each of the fields has multiple records and I want to create 1 field to display all of the records

e.g

ZZMLST_ZAEHL1 may contain :

ZZMLST_ZAEHL2 may contain:

I want to create a field so I can see

Re: Creating one field from multiple fields in a load script

PrashantSangle — Thu, 24 Sep 2015 08:00:47 GMT

Hi,

look at cross table concept. Might be helpful to you.

Regards

Re: Creating one field from multiple fields in a load script

Thu, 24 Sep 2015 09:16:10 GMT

For vCounter = 1 to 5

LOAD

'$(vCounter)' as fieldtype,

zzmlst'$(vCounter)' as Milestone

FROM ...

That should perfectly work. You will read the initial table 5 times.

I added a field named fieldtype so you can still see from which field the data came from

If the table contains a lot of data, you should first read the table in memory and then perform the for...next loop as reading it from memory is a lot faster than through ODBC.

Re: Creating one field from multiple fields in a load script

settu_periasamy — Thu, 24 Sep 2015 09:53:05 GMT

Try this script

Table1:

CrossTable(Field, Data)

LOAD RowNo() as Row1,

ZZMLST_ZAEHL1,

ZZMLST_ZAEHL2,

ZZMLST_ZAEHL3,

ZZMLST_ZAEHL4,

ZZMLST_ZAEHL5;

LOAD * INLINE [

ZZMLST_ZAEHL1, ZZMLST_ZAEHL2, ZZMLST_ZAEHL3, ZZMLST_ZAEHL4, ZZMLST_ZAEHL5

16, 45, 89, 35, 52

85, 69, 12, 40, 10

18, 50, 62, 79, 40

71, 100, 37, 84, 79

19, 32, 13, 25, 97

16, 76, 47, 40, 39

];

NoConcatenate

Load Data as Milestone Resident Table1;

DROP Table Table1;