Is there a way to join a single row table in InfoAssist if there is no key field? I have a table which consists of a single row of processing dates I want to use to filter the data in my main table. I'm not sure how to do this in InfoAssist.
Thanks!

This message has been edited. Last edited by: DWaybright,

Not sure if applicable to IA (WHERE ... IN FILE ...) but having your file in ALPHA format you can then have it in a WHERE clause such as below pseudo-code.
Assuming that there is only one date in the file.

TABLE FILE DATE_FOR_FILTER
PRINT FLT_DATE
ON TABLE HOLD AS DTE_FLT FORMAT ALPHA
END
-RUN

TABLE FILE abc
...
WHERE myDt_Field IN FILE DTE_FLT;
END

Dwaybright

I successfully joined a non-keyed flat file to another file and got results. It gave me a warning it wasn't indexed but still worked. I joined the single row table to the other table.

Thanks. I've been able to get the data I need.

Please share your solution for others to benefit from FocalPoint Posts.

Thanks You, Doug