Hello Sector,
you can't put text parameters ' Sample##OTHER## ' in a lookup table.
A lookup table can only have length and angle parameters in it.
you have to translate that text to a number or integer and search for that in of the columns in the Lookup table.
Try also this trick:
add a column with parameter 'info_code' to the and of the lookup table. (info_code##length##milimiters)
look for that info_code by using the Size Lookup. info_code = size_lookup(Lookup Table Name, " info_code ", Nominal Diameter, Nominal Diameter)
then use a formula to get the text back.
for example:
Text = if(info_code =1, "Text1",if(info_code =2, "Text2",if(info_code =3, "Text3","Unknown")))
You could also read column A from the CSV file. You are allowed to place text here.
Text = size_lookup(Lookup Table Name, "", "Unknown", Nominal Diameter)
Hope this helps.
Please let me know if you managed.
If my post answers your question, please click the "Accept as Solution" button. This helps everyone find answers more quickly!
Kind regards,
Robert Klempau
Senior Consultant AEC
Cadac Group AEC BV