Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm running a script like the following, but getting an error that my last table Group_Data_Amb cannot find the Resident table. In other forums people suggested NoConcatenate, however even though both of the DCAPBS tables load, the third fails to load. What am I missing? (And yes, I have a very specific reason for loading a duplicate table, which will be dropped once the error goes away).
Table not found error
Table 'DCAPBS_DUPE' not found
Group_Data_Amb:
NoConcatenate
LOAD
"Provider Name"
Resident
DCAPBS_DUPE
DCAPBS: NoConcatenate LOAD distinct * ; SQL Select Distinct ACCESS, "Provider Name", "Billing Provider" From TABLE A; DCABPS_DUPE: NoConcatenate LOAD distinct * ; SQL Select Distinct ACCESS, "Provider Name", "Billing Provider" From TABLE A; Group_Data_Amb: NoConcatenate LOAD "Provider Name" Resident DCAPBS_DUPE;
Hi, one is DCABPS_DUPE, the other DCAPBS_DUPE
Hi, one is DCABPS_DUPE, the other DCAPBS_DUPE