Loading script Add column

[#1]

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

[Anonymous]

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

[#3]

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

[Anonymous]

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

[Gysbert_Wassenaar]

Something like this:

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

From ...

[#6]

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

[Anonymous]

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;

[#8]

Add this below to expression to have new column.

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

Thanks.