Hi, i want to know if indexing line and column is possible

nic__o

Hi, i want to know if  indexing line and column is possible, i want to peak one specific cell of an Excel tab, like [i][j], i tried a lot of operator wihout sucess...

I will really appreciate your answers, 
Thank you

lionelderkrikor

Hi again @nic__o,

Yes, it's possible. You have to use 2 Extract Macro operators with these settings : 


 
Hope this helps,

Regards,

Lionel

lionelderkrikor

Hi @nic__o ,

You can use Extract Macro operator with  : 
 - macro type = data_value (the you choose the example index and the attribute name)

Regards,

Lionel

nic__o

Thank's you Lionel its working, but is there a dynamic way to do it ? I mean, for example if I want to pick the last element of a column for any files in entry, is this could be possible ?
Best regards,

lionelderkrikor

Hi again @nic__o,

Yes, it's possible. You have to use 2 Extract Macro operators with these settings : 


 
Hope this helps,

Regards,

Lionel

MartinLiebig

Hi,

i think you can btw use -1  as example index to get the last item.

Best,

Martin

lionelderkrikor

Hi @mschmitz,

I must admit that it is a more elegant solution...
I'm a too complicated boy...

Regards,

Lionel