Skip to main content
Answer

Replace Data on filed GI

  • October 16, 2024
  • 3 replies
  • 74 views

Hello, me again 😅

 

In the file I'm working on, I have a situation where the warehouse for some part numbers is not displayed.
I added a formula to replace the blank spaces with the selected warehouse, but it gives it to me in the form of a number.

Is there a way to change it to text?
Can this formula be defined from the table relationship?

 

Best answer by dcomerford

Join the InSite table in your GI using the SiteID and then change it to get show the SiteCD from this table.

3 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • October 17, 2024

@JavierGtz Can you please export and share this GI here?


dcomerford
Captain II
Forum|alt.badge.img+15
  • Captain II
  • Answer
  • October 17, 2024

Join the InSite table in your GI using the SiteID and then change it to get show the SiteCD from this table.


  • Author
  • Freshman I
  • October 18, 2024

Thanks for your answers I was able to get it working!!