topic Re: Loading script Add column in QlikView

Loading script Add column

Fri, 27 Dec 2013 08:57:54 GMT

Hello,

My data:

Table:

Timestamp User Type Object

1 J Sheet SH15

2 J Selection Filter1

3 J Selection Filter2

4 J Sheet SH17

5 J Selection Filter1

It means that the user J have selected Filter 1 and Filter 2 in the sheet SH15 .

I would like to have another column "Sheet" in my table to know what filter corresponds to what sheet.

Do you have any ideas?

Thank in advance

Re: Loading script Add column

Anonymous — Fri, 27 Dec 2013 09:05:39 GMT

just add a field as

Table:

Timestamp User Type Object Sheet

1 J Sheet SH15 Sheet15

2 J Selection Filter1 Sheet15

3 J Selection Filter2 Sheet15

4 J Sheet SH17 Sheet17

5 J Selection Filter1 Sheet17

Re: Loading script Add column

Fri, 27 Dec 2013 09:07:42 GMT

I can't do that because there are a lot of data

Re: Loading script Add column

Anonymous — Fri, 27 Dec 2013 09:11:36 GMT

from where are you loading this data..

We can get the sheet id at front end , i dont think that there is any function to get it at script level.

May be from your datasource only we can check if a new relevant column can be added

Re: Loading script Add column

Gysbert_Wassenaar — Fri, 27 Dec 2013 09:12:19 GMT

Something like this:

Load Timestamp, User, Type, Object, if(Type='Sheet',Object,peek('Sheet')) as Sheet

From ...

Re: Loading script Add column

Fri, 27 Dec 2013 09:12:27 GMT

Claire,

You can export the structure of your document: Settings / Document Properties / tab Sheets / button Export Structure

Then, you can do 1) a mapping Load to load this structure (link between your object and the dimension) 2) do an applymap() as newCol to create the new column

Fabrice

Re: Loading script Add column

Anonymous — Fri, 27 Dec 2013 09:16:04 GMT

Table_temp:

load * inline[

Timestamp User Type Object Sheet

1 J Sheet SH15 Sheet15

2 J Selection Filter1 Sheet15

3 J Selection Filter2 Sheet15

4 J Sheet SH17 Sheet17

5 J Selection Filter1 Sheet17

];

noconcatenate

Table:

Load *

if(left(Object,2)='SH',Object,peek(Object,-(mid(7)))) as Sheet

resident Table_temp;

Drop tale table_temp;

Re: Loading script Add column

Fri, 27 Dec 2013 09:20:42 GMT

Add this below to expression to have new column.

If(match(Object,'Filter1','Filter2'),'Sheet15','Sheet17')

Thanks.