topic Combining if condition and set a variable inside load table statement in App Development

Combining if condition and set a variable inside load table statement

chriys1337 — Sun, 29 Aug 2021 13:48:52 GMT

I try to set a variable with a if condition when a field value (measure) is 1.

table:

Load

FieldA,

FieldB,

measure

FROM...

FieldA, Field B, measure

Porsche, Cayenne, null

VW, Golf, 1

Jeep, Renegade, null

if measure is 1, I would like to set a variable with value from Field B, so in my example I would like to set vVariable to Golf but I dont know how to set a variable inside the load statement combined with a if statement.

Any help is appreciated, thanks a lot!

Re: Combining if condition and set a variable inside load table statement

Or — Sun, 29 Aug 2021 15:59:54 GMT

I don't think you can do that directly from a load statement. You could loop through the values, but that's only feasible if the number of rows is on the small side. If you elaborate on what exactly you're trying to achieve, perhaps there's a workaround to be suggested.

Re: Combining if condition and set a variable inside load table statement

Saravanan_Desingh — Sun, 29 Aug 2021 16:07:09 GMT

Try something like this,

tab1: LOAD * INLINE [ FieldA, Field B, measure Porsche, Cayenne, null VW, Golf, 1 Jeep, Renegade, null ]; FieldB1: NoConcatenate LOAD DISTINCT [Field B] As Var Resident tab1 Where measure=1 ; LET vVariable=Peek('Var',0,'FieldB1'); Trace vVariable=$(vVariable); Drop Table FieldB1;

Re: Combining if condition and set a variable inside load table statement

Kushal_Chawda — Sun, 29 Aug 2021 16:27:08 GMT

@chriys1337 what if you have more than one value for measure=1?