Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
Anonymous
4597 Views, 13 Replies

iLogic help to create multple MultiValue.List from an Excel

please help! i'm stuck :disappointed_face:

 

here is a simplified example of what i am trying to do...

 

Excel_test.JPG

 

i trying to create multiple MultiValue.List from Excel, and here is a small snippet that i know works...

 

MultiValue.SetList("SIZE", "SIZE-AA", "SIZE-BB", "SIZE-CC")

If SIZE = "SIZE-AA" Then
	GoExcel.TitleRow = 2
	MultiValue.List("MODEL") = GoExcel.CellValues("filename.xls", "Sheet1", "A3", "A5")
ElseIf SIZE = "SIZE-BB" Then
	GoExcel.TitleRow = 7
	MultiValue.List("MODEL") = GoExcel.CellValues("filename.xls", "Sheet1", "A8", "A10")
ElseIf SIZE = "SIZE-CC" Then
	GoExcel.TitleRow = 12
	MultiValue.List("MODEL") = GoExcel.CellValues("filename.xls", "Sheet1", "A13", "A15")
End If

so now, what i would like to do is create another MultiValue.List from the first MultiValue.List.

 

for example, if i select "SIZE-AA" from my "SIZE" multi-list (SIZE-AA, SIZE-BB, SIZE-CC), my next list from "MODEL" would give me "AA100, AA110, AA210", then my next list for eg. "AA110" would be "10, 20, 30,40".

 

can this even be done?

thanks