Skip to main content
Question

Creating dropdown in Excel Migration Job

  • April 28, 2020
  • 1 reply
  • 207 views

eqbstal
Superhero (Partner)
Forum|alt.badge.img+21
  • Superhero (Partner)
  • 677 replies

Using the Excel Migration Job is very nice. I've noticed that sometimes a dropdown on fields is opening up in Excel. It seems to come from the settings in IID Values

Fig 1 - IID Values

So in this case there is the Manufacturer Number field. I know the content of IID Values is weird, but this is just for the examples sake (please bear with me).

This results in the following:

Fig 2 - Boolean values as dropdown values

If I change the IID Values to something like (have to duplicate the line, make the change in the new line and delete the original one):

Fig 3 - Different LU used on IID Values

This leads to the following dropdown values in Excel:

Fig 4 - Resulting Dropdown

These come from basic data:

Fig 5 - Basic data

I've noticed that this doesn't work for all LUs. So if I used a different LU as in Figure 3 I would assume different dropdown values in Excel. However that is not the case. Most of the time it doesn't work.

Question: Does anybody have a clue how this works? So what setting is really driving the dropdown? Is it the API connected to the LU? Is it the type of LU as stated in the spec of the API?

Thanks in advance,

Steve

1 reply

Curious_User
Sidekick (Customer)
Forum|alt.badge.img+8

I would be interested in seeing an answer on this too.

I am trying to do the same by trying to get a dropdown for ISO_UNIT for Units of Measure in another table for the Excel Migration.


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