topic Re: how to Load * Inline with field reference within range of values in App Development

how to Load * Inline with field reference within range of values

Marcushenriquesk — Wed, 27 Jul 2022 16:46:37 GMT

So I have a table called Panels. It contains a list of panel_names based on Panel_id. For example, Panel_ID = 1 has Panel_name = 'First_Panel_Name.' I want to create a scalable structure so that instead of using individual Panel_ids for the conditions within our functions we can use a load * Inline Table. It would look something like this:

PanelType :
load * Inline [
PANEL_ID, PanelType

if(PANEL_ID >70001 and PANEL_ID < 70075, Oral Fluid

if(PANEL_ID >65001 and PANEL_ID < 65018, Oral Fluid

];

however, It doesnt recognize the if condition and just makes the selection ' if(PANEL_ID >65001 and PANEL_ID < 65018' = 'Oral Fluid'

Re: how to Load * Inline with field reference within range of values

MarcoWedel — Wed, 27 Jul 2022 18:47:10 GMT

can you post how "It doesnt recognize the if condition and just makes the selection ' if(PANEL_ID >65001 and PANEL_ID < 65018' = 'Oral Fluid'"?

How do you use this table?

Re: how to Load * Inline with field reference within range of values

Marcushenriquesk — Wed, 27 Jul 2022 18:59:20 GMT

this table will be used for conditional filteres within the functions of the charts in our apps. For example instead of creating a function : ''Count( distinct If(Panel_id >=0 and Panel_id <=10, ACC_ID)" we would use : "Count( Distinct if(PanelType = 'Oral Fluid', ACC_ID)"

Re: how to Load * Inline with field reference within range of values

tealowk — Wed, 27 Jul 2022 19:26:44 GMT

Hi @Marcushenriquesk,

IMHO you don't need the PanelType table.

In the LOAD statement of your main table, just define this additional field:

LOAD *,

if(PANEL_ID >70001 and PANEL_ID < 70075, Oral Fluid, if(PANEL_ID >65001 and PANEL_ID < 65018, Oral Fluid, 'Other') AS PanelType

FROM mySource;

Re: how to Load * Inline with field reference within range of values

tealowk — Wed, 27 Jul 2022 19:31:49 GMT

These expressions should be replaced with the corresponding set analysis expressions.

Old: Count( distinct If(Panel_id >=0 and Panel_id <=10, ACC_ID)

New: Count( {<Panel_id={">=0 <=10"}>} distinct ACC_ID)

Old: Count( Distinct if(PanelType = 'Oral Fluid', ACC_ID)

New: Count( {<PanelType={'Oral Fluid'}>} Distinct ACC_ID)