0

How to get index row value of dataTable component

Hi,

I am building a new dashboard.

I want to use table data inside the formula for the new column.

Example table:

 

I want to get: !Column: Kanal [ index ]

Example for:  !Column: Kanal [3]  my expected value will be: BING,BING,SEARCK-REM

for:  !Column: Kanal [5]  my expected value will be: BEBERSETZUNGEN/UEBE..

.....

But If I add [] inside my formula I get the error:

Example:

Is there any possibility of obtaining the values from the table?

Thank you for your answer.

Best regards, Boštjan

2 comments

  • 0
    Avatar
    Meggan King

    Hi Boštjan,

     

    In your example you are doing a SLICE by column - SLICE(E:E), SLICE(N:N). You can also do a SLICE by row, so you could do SLICE(3:3) and select the data right from your data source. To only get the first column, you could do SLICE(3:3,0,1) 

     

    If there needs to be a formula to select just that cell, it would get slightly more complex. If you still need help, please contact support@klipfolio.com and we can have a look at your exact formula. 

     

    Thanks

    Meggan

  • 0
    Avatar
    Boštjan Kotnik

    Meggan, thank you for your help.

Please sign in to leave a comment.