Want to extract values from excel and use in 'data item in 'Calculate data' operator ('sensor link')

Himanshu_Pant
New Altair Community Member
Answers
-
You can use 'rename by example' operator to do something like this, if your first row contains your labels you just add row number 1 (the default).
If your labels are all in a row you may need to pivot first.0 -
Actually here I am not looking for renaming. I want to use all the values of a column (may by using a macro) in 'edit parameter list' of 'data item' in 'Calculate data' operator ('sensor link'). I want to avoid the process of adding the parameter manually.0
-
Ah, in that case you probably need to combine the loop examples and the extract macro operators.
So you loop through the example, for each example you extract the value you need to a macro, and then use that macro for your sensor link.
Something like that...0 -
ya, that was my first approach. But Since the dataset is high, the system is getting hanged. So I was looking for a process which doesn't use loop. Instead, if we can directly supply value to 'edit parameter list' of 'data item' in 'Calculate data' operator ('sensor link').0
-
@mschmitz Can you please help me with this?0
-
Do you use the 'remove unused values' operator during your loop?
I'd recommend this for bigger sets, as this way you only use the relevant data, while otherwise the 'hidden' metadata remains part of your flow.
This can have a huge effect on speed and memory when dealing with loops and filters on bigger sets.
I use it by default on every step where I need to filter or loop.0