Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Loading values under a Field separately as it own field

Hello QV Users,

I'm new to Qlik View and will appreciate your help on the following.

I have a Data Field labelled Pool with various Pool Types under that Field named DD, EX, PLC, BB, PO3, PO6. I will like in load script to load each Pool Type separately as it own field. Can anyone help with this please.

Thanks

Wade

9 Replies
MVP
MVP

Re: Loading values under a Field separately as it own field

Please post some sample data records.

p_verkooijen
Valued Contributor

Re: Loading values under a Field separately as it own field

If you're data is like this:

PoolDDEXPLCBBPO3PO6
A3242245
B1122351323
C134121

You should try to load it as a crosstable.

Then you will end up with a table like.

 

PoolTypeData
ADD3
AEX2
APLC4
ABB2
APO32
APO645
BDD1
BEX12
etc
Not applicable

Re: Loading values under a Field separately as it own field

Paul,

On my initial load, the data will show up like this when i create a list box

Pool

DD

EX

PLC

BB

PO3

PO6

What i want to achieve is to create a syntax in the load script to load the data for each Pool Type individually so when i create a list box i can do each one separately.

Example: Pool    Pool2    Pool3    Pool4      Pool5    Pool6

              DD      EX         PLC       BB          PO3       PO6

Hope that clarifies what i want to get done

Thanks

Wade

Not applicable

Re: Loading values under a Field separately as it own field

Swuehl,

On my initial load, the data will show up like this when i create a list box

Pool

DD

EX

PLC

BB

PO3

PO6

What i want to achieve is to create a syntax in the load script to load the data for each Pool Type individually so when i create a list box i can do each one separately.

Example: Pool    Pool2    Pool3     Pool4

               DD      EX         PLC       BB

Hope that clarifies what i want to get done

Thanks

MVP
MVP

Re: Loading values under a Field separately as it own field

And what do you want to achieve with this table? How do you want to interact / use these fields?

I guess there are some other fields involved, how are these related and what is your final requirement?

Not applicable

Re: Loading values under a Field separately as it own field

Yes, there are other data fields that is associated with the field Pool. I want to be able to make each Pool Type a selected field. In that way i can make manual calculation on specific pool type within my data set.

Thanks

Wade

elizafilip_2014
Contributor II

Re: Loading values under a Field separately as it own field

Hello Wade,

Have a look here: The Generic Load

I thing this is what you what to get done.

MVP
MVP

Re: Loading values under a Field separately as it own field

I doubt this will work as you intend to work. Or maybe I am still not understanding your setting and what you want to achieve. Could you elaborate this maybe with a demo scenario (When I select Ex in field Pool2, I want ... and then I want ....)? Some sample records that illustrate your demo would be nice.

Or in case this is easier for you:

Assuming a table like

A, B, Pool

1, 2, DD

1, 3,  EX

2, 4, PLC

How you want this table to be transformed? As I said, I doubt that the transformation would be better than the current state, at least as I can envision what you want to do.

Not applicable

Re: Loading values under a Field separately as it own field

Thanks Eliza,

This was very helpful and i can use this to achieve the results am looking for. However if you still know of another way of doing this using just the field pool please let me know. With the Generic Load i have to use at least three (3) fields to get the results am looking for. Will prefer something where i can just use field Pool.

Thanks

Wade

Community Browser