topic Re: Create and Add Field to Table in QlikView

Create and Add Field to Table

greend21 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

If I have a bunch of phone data such as # of calls, talk time, split #, etc is it possible to load this data and then add another field where Split 1 = Group A and Split 2 = Group B for filtering purposes? Or would I have to go back to my data and add Group 1 next to all Split 1 fields?

I wasn't sure if I would need to make that a small inline table and then join the two.

Thanks,

Dan

Re: Create and Add Field to Table

maxgro — Fri, 03 Nov 2017 17:47:33 GMT

could you add a small example, some rows with the result you want?

thanks

Re: Create and Add Field to Table

greend21 — Fri, 03 Nov 2017 17:53:43 GMT

Current data would look like:

Split User # of Calls

1 1 4

1 2 5

2 3 4

1 4 7

2 5 3

The real data is hundreds of lines so I was wondering if there was a way within the script to make split 1 part of group A and split 2 part of group B like this:

Group Split User # of Calls

A 1 1 4

A 1 2 5

B 2 3 4

A 1 4 7

B 2 5 3

I could then display the Group in the data rather than Split as this would be more user friendly.

Re: Create and Add Field to Table

maxgro — Fri, 03 Nov 2017 18:08:18 GMT

add the field when you load the data, something like

load

Split,

User,

[# of Calls],

pick(match(Split, 1, 2), 'A', 'B') as Group

from

.....

Re: Create and Add Field to Table

Anonymous — Fri, 03 Nov 2017 18:10:06 GMT

You could no a join or apply map to a list of unique groups and splits. Something like:

Data:

Load

Split,

User,

[# of Calls]

From

YourDataFile;

inner join(Data)

Load

GroupName,

Split

From

YourGroupFile;