question

Ankur A3 avatar image
0 Likes"
Ankur A3 asked Kavika F commented

InnerJoin Not Working Properly With SQL Query

Hi Team,

I have actual data in global table only for 2 weekdays (Thu and Fri) but I have to show data in results table for all weekday (Mon, Tue, Wed, Thu, Fri, Sat, Sun) keeping data for other days as 0. While using SQL query I tried to get results in calculated table. But I can't see Mon in results table.

1652088618786.png



Can you help me to know the issue here?

Thank you!

9.InnerJoinNotWorkingProperly.fsm

Other (please specify)
Other
querysqlinnerjoin
· 4
5 |100000

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

Felix Möhlmann avatar image Felix Möhlmann commented ·

I can't replicate the issue. When I update the calculated table, monday appears as would be expected.

1652092757081.png

If haven't done so yet, please try downloading the latest bugfix for your version (21.1.5).

0 Likes 0 ·
1652092757081.png (4.0 KiB)
Ankur A3 avatar image Ankur A3 commented ·

Ok @Felix Möhlmann

Actually, I am still facing same issue.

I don't know how to download this bugfix if I am using licensed version.

0 Likes 0 ·
Felix Möhlmann avatar image Felix Möhlmann Ankur A3 commented ·

The start page will show icons next to the version number, if there is a newer version or bugfix available to download. (Icons might look different in the 21.1 version)

1652105556479.png

The versions in the downloads section of your FlexSim Profile will also be the most recent ones.

If that doesn't help you might have to wait until a developer can have a look at the issue.

0 Likes 0 ·
1652105556479.png (1.5 MiB)
Kavika F avatar image Kavika F ♦ commented ·

Hi @Ankur A3,

We haven't heard back from you. Were you able to solve your problem? If so, please add and accept an answer to let others know the solution. Or please respond to the previous comment so that we can continue to help you.

If we don't hear back in the next 3 business days, we'll assume you were able to solve your problem and we'll close this case in our tracker. You can always comment back at any time to reopen your question, or you can contact your local FlexSim distributor for phone or email help.

0 Likes 0 ·

0 Answers