Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
lichang422
Creator
Creator

Could I make 3 table without relation

I made 3 tables and resource is from the same data.

未命名.jpg

Table 1(CNC Status) : Filter the SimpleSignalName = FAN , Bat , Act ....etc

Table 2(Servo Status) : Filter the SimpleSignalName = Amp , Zero , Temp ....etc

Table 3(Spindle Status) : Filter the SimpleSignalName = Spindle , spd  ....etc

未命名.jpg


Original , I think 3 tables are without relation ,When I select someone in table 1

Table 2 and Table 3 data are disapointed.

Maybe you will ask why i don't select at making table,Because I want to make some default data to support customer to select.

So how could i make it without relation??

未命名.jpg

21 Replies
lichang422
Creator
Creator
Author

Sorry, I am not sure where is wrong.

It is difficult to me.

Can you help me to check where is missing.

未命名.jpg

未命名.jpg

未命名.jpg

petter
Partner - Champion III
Partner - Champion III

Each WildMatch(SimpleSignalName  has to be changed to

WildMatch(CNC.SimpleSignalName / WildMatch(Servo.SimpleSignalName / WildMatch(Spindle.SimpleSignalName

And the right tablename has to be specified at the end in the DROP TABLE statement - the same as in the three LOAD statements:

[L1Signal......514]      

lichang422
Creator
Creator
Author

Sorry, In the auto generate section,The content likes below :


Unqualify *;


[L1Signal_Pool_Active_temp_a9dd18a6-4dfe-37a6-c3c5-fb029afa]:

LOAD

[L1Name],

[signalname],

[value],

Replace([signalname],'_'&[L1Name],'') AS [SimpleSignalName]

RESIDENT [L1Signal_Pool_Active];

DROP TABLE [L1Signal_Pool_Active];


RENAME TABLE [L1Signal_Pool_Active_temp_a9dd18a6-4dfe-37a6-c3c5-fb029afa] to [L1Signal_Pool_Active];




So When I create a new section.

QUALIFY *;

[CNC]:

LOAD

[L1Name],

[signalname],

[value],

[SimpleSignalName]

FROM

[L1Signal_Pool_Active_temp_70ddf4c0-8c06-6a9b-b31e-5ea0adc3]

WHERE

  WildMatch(SimpleSignalName, '*sig*','*pro*','*comment*','*modal*','*parts*','*time*','*cnc*','*emg*','*mode*','*seq*');

UNQUALIFY *;

DROP TABLE [L1Signal_Pool_Active_temp_70ddf4c0-8c06-6a9b-b31e-5ea0adc3];



Should I need to change underline same as auto generate section ??

petter
Partner - Champion III
Partner - Champion III

Sorry - I was a bit too quick... the code should refer to the original table name like this in four different places:

QUALIFY *;

[CNC]:

LOAD

[L1Name],

[signalname],

[value],

[SimpleSignalName]

FROM

  [L1Signal_Pool_Active]

WHERE

  WildMatch(CNC.SimpleSignalName, '*sig*','*pro*','*comment*','*modal*','*parts*','*time*','*cnc*','*emg*','*mode*','*seq*');


[Servo]:

LOAD

[L1Name],

[signalname],

[value],

[SimpleSignalName]

FROM

  [L1Signal_Pool_Active]

WHERE

WildMatch(Servo.SimpleSignalName, '*servo*','*pos*','*pulse*','*zero*','*srv*','*apc*');

[Spindle]:

LOAD

[L1Name],

[signalname],

[value],

[SimpleSignalName]

FROM

  [L1Signal_Pool_Active]

WHERE

  WildMatch(Spindle.SimpleSignalName, '*spdl*','*spindle*','*acts*','*sigenb*');


UNQUALIFY *;

DROP TABLE [L1Signal_Pool_Active];

lichang422
Creator
Creator
Author

It is so terrible, I can't success it.

I had reduce sentence,But Alarm is still.

Can you help me again ?? Thank you!!

未命名.jpg

petter
Partner - Champion III
Partner - Champion III

My fault - I do some basic mistakes myself since I am "dry" coding here without having access to something I can verify...

You have to replace all FROM to RESIDENT for the three LOAD statements.


For the first one it would look like:

[CNC]:

LOAD

   [L1Name],

   [signalname],

   [value],

   [SimpleSignalName]

RESIDENT

  [L1Signal_Pool_Active]

WHERE

  WildMatch(CNC.SimpleSignalName, '*sig*','*pro*','*comment*','*modal*','*parts*','*time*','*cnc*','*emg*','*mode*','*seq*');


lichang422
Creator
Creator
Author

Sorry,When I directly copy your code to test.

It show like below.

未命名.jpg

So I re-code about WHERE parts like below

WHERE WildMatch('CNC.SimpleSignalName', '*sig*','*pro*','*comment*','*modal*','*parts*','*time*','*cnc*','*emg*','*mode*','*seq*');

It looks like success.

But I can't feel any different.

Is it right?

Or where i need to care ??

未命名.jpg

lichang422
Creator
Creator
Author

Hi,Petter

     Do you see my reply ? Does I modify it correctly ??

Why I can't see another bubble(like CNC bubble)

Or I mistake something ??

petter
Partner - Champion III
Partner - Champion III

Does the reload run successfully?

Can you share a screenshot of the Data Model Viewer ?

lichang422
Creator
Creator
Author

Sorry, I've been bothering you

未命名.jpg

未命名.jpg