How to compare table values

Question

question

Urvi Sukharamwala asked Mar 4, '24 Jason Lightfoot commented Mar 8, '24

How to compare table values

Hello,

How should I fetch and compare(with the data fetched from API) the values of the highlighted column in the below given image using flexscript.

Software Version:

FlexSim 24.0.1

global table flexscript

1709583859207.png (7.1 KiB)

· 1

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Jason Lightfoot ♦♦ commented · Mar 08 at 01:59 PM

Hi @urvi-sukharamwala, was Jason Lightfoot's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always comment back to reopen your question.

0 ·

Answer 1 · 2024-03-04T22:07:03Z

Jason Lightfoot answered Mar 4, '24 Jason Lightfoot edited Mar 4, '24

Those values are irrelevant. They don't identify anything related to the data , which if I recall is keyed on userid and id.

· 2

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Urvi Sukharamwala commented · Mar 04 at 10:40 PM

Hey Jason,

Thank you for the response. This is dummy data however in the data and model I have, has the name of processes and that table doesn't have userID or ID. So what will be your suggestion in that case

0 ·

Jason Lightfoot ♦♦ Urvi Sukharamwala commented · Mar 04 at 11:47 PM

When you're creating your export just set the the process attribute as you loop through the rows:

myExportMap["process"]=myTable.getRowHeader(rownum);

Or if you want to use the process in queries copy the rowheader to a new column in the table (again using a loop after you've added a string column called 'Process' or similar).

0 ·

question