Forum Discussion

DouweMeer's avatar
DouweMeer
Icon for Impactful Individual rankImpactful Individual
5 years ago

Expressions that yield variant data type cannot be used

I created a logic to combine a product description from multiple excel files. At one point it started giving me a data variant error so I was looking for numbers in my expression. I was unable to fin...
Need Help
v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
5 years ago

Hi DouweMeer ,

Based on your description, perhaps you can try to put the a6 variable in the last swtich() statement to get the result:

Column =
VAR a1 =
    BLANK ()
VAR a2 =
    BLANK ()
VAR a3 =
    BLANK ()
VAR a4 =
    BLANK ()
VAR a5 =
    BLANK ()
VAR a6 = "1"
RETURN
    SWITCH (
        TRUE (),
        a5 <> BLANK (), a5,
        a2 <> BLANK (), a2,
        a4 <> BLANK (), a4,
        a1 <> BLANK (), a1,
        a3 <> BLANK (), a3,
        a6 <> BLANK (), a6,
        BLANK ()
    )

 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

DouweMeer's avatar
DouweMeer
Icon for Impactful Individual rankImpactful Individual
5 years ago

v-yingjl 

Strange that this removes the behavior. Although extremely unfavourable as this expression is meant to swtich between product tabels dependable on priority. In some fields some of the sources do not have a related data field and therefore a blank is entered in the VAR. If I would change the position for each field to make sure that the last VAR is always filled in, it becomes a mess to write, maintain, and check on it. 

I'll report a ticket to make sure they fix this. It shouldn't be like this.