Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Isblank function and concatenate in Direct Query

I wanna create a column "Bay & Level" using PickAisle, PickModule, PickBay & PickLevel. Eg: 42B-003-3. If the value is NULL, I want it to be blank.  Mode: Direct Query I am getting the values corr...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi Anonymous,

     

    try the following formula:

     

    [PickAisle] & "-" &(if [PickModule] = null then " " else [PickModule]) & "-" & [PickBay] & "-" & [PickLevel]

    Regards,

    MFelix

     

     

MFelix's avatar
MFelix
Super User
8 years ago

Hi Anonymous,

 

try the following formula:

 

[PickAisle] & "-" &(if [PickModule] = null then " " else [PickModule]) & "-" & [PickBay] & "-" & [PickLevel]

Regards,

MFelix

 

 

  • workonpower's avatar
    workonpower
    New Member
    6 years ago

    Hi, can I see the whole formula for this please?

     

    • MFelix's avatar
      MFelix
      Super User
      6 years ago

      Hi workonpower ,

       

      Not sure if this is what you are refering to but:

       

       

      [PickAisle] & "-" & (
  if [PickModule] = null then " "
  else [PickModule]) & "-" & [PickBay] & "-" & [PickLevel]

       

      This formula is for M language used in the query editor.

       

      Regards,

      MFelix