Skip to main content
Solved

Substitution lists with GIs

  • November 15, 2024
  • 2 replies
  • 64 views

estebanperalta54
Captain II
Forum|alt.badge.img+4

Hi! Does anyone know if you can use substitution lists with GIs? I’m trying to use them instead of using a long IF formula. This is what it looks like and the error:

 

 

 

Best answer by estebanperalta54

I looked further into it and  learned that the Substitution lists do not work in Generic Inquiries and are only meant to be utilized in Import Scenarios. Instead, I used a switch formula:

 

View original
Did this topic help you find an answer to your question?

2 replies

josborn02
Jr Varsity I
Forum|alt.badge.img
  • Jr Varsity I
  • 50 replies
  • November 15, 2024

You could create another GI and use it as a subquery that contains all the lookup values you need for the primary GI.  This functionality was released in 2024 R1.


estebanperalta54
Captain II
Forum|alt.badge.img+4
  • Author
  • Captain II
  • 123 replies
  • Answer
  • November 18, 2024

I looked further into it and  learned that the Substitution lists do not work in Generic Inquiries and are only meant to be utilized in Import Scenarios. Instead, I used a switch formula:

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings