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

New Altair Community Member
Updated by Jocelyn
I have an excel which contain a column name. I want to use the values of column name in 'data item' in 'Calculate data' operator ('sensor link'), so that manual efforts of adding values in 'data item' will get reduced.
Find more posts tagged with
Sort by:
1 - 7 of
71
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').
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.
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.
If your labels are all in a row you may need to pivot first.