Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

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

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

Find more posts tagged with

AI Studio

Accepted answers

lionelderkrikor

Hi again @nic__o,

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

Image: https://us.v-cdn.net/6030995/uploads/editor/bp/x9451332ocxd.png

Hope this helps,

Regards,

Lionel

All comments

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