i have to load data from a multiple table, which is quite identical, but one of them is missing a field , let's say country. i load in a loop, so the it's arrive at the problem one he just gave an erros and stops, is there a way to check at loading if the field exist and loading a default value . i have try: iif(TYPE("country")='none',country) as country.
from what i realized the problem is not in the fir part of iif, because if i put after = 'none','other', it work whithout an error, but he try to evaluate contry although he should not.
i have try it but id does not work , because this table is in 17 data source , and from each source i have to load from every month of the last 3 years so i use a repetitive comand with a for i to ....
