Load if statement multiple expressions

[snowman]

Hi there,

Just would like to know if there is a way under If statement in the Load script to have multiple expressions. For example:

If a=1, p As X, q As Y, r As Z     // (a, p q, r are data fields)

instead of having 3 If statements.

Thanks

[DavidM]

Does this mean, that if a=1 you load those three fields and otherwise not? You can do it with multiple loads with conditions (where a=1) and concatenate tables.

[snowman]

Hi DavidM,

Yes, actually if the field a = 1, it shall load 50 fields, otherwise do nothing.

I can use 50 IF to complete this, but wonder if I can simply use one IF with 50 then expressions to make the coding look neat.

Thanks

[Brett_Bleess]

Snowman, only other thing that came to mind might be the following Design Blog:

https://community.qlik.com/t5/Qlik-Design-Blog/Preceding-Load/ba-p/1469534

Not sure if it will help or not, figured it was worth pointing out.

Regards,
Brett