How to remove $Syn 1 from my table structure ?

[paulyeo11]

Hi All

I have just create a AP AR ARSummary and Sales Table.

I like to make my table more neat .

Can some one tell me how to remove the $Syn1 ?

I no it is no affect to my app , i just want to learn how to remove it.

Paul

[miguelbraga]

Forgot this symbol ';' try put this:

Qualify *;

Unqualify SOURCE;

Regards,

MB

[miguelbraga]

You'll need to create the Key that I've told you in this 3 tables:

Then comment 2 SOURCE field in 2 of the 3 tables, and you're good to go

Regards,

MB

[paulyeo11]

Hi Miguel

Now working fine after i place ; at the end of the script.

I notice that this is good , because it make my data model very neat.

thank a lot.

Paul

[paulyeo11]

Hi Miguel

I only use my old script :-

autonumber( @1:9T & '_' & 'TDSS' ) as ARKey,

I never use your script :-

Autonumber(SOURCE & '-' & ARKey) as [%SOURCE-ARKey],

because i get error.

Now this is my data model. it is correct. ?

[paulyeo11]

Hi Miguell

I just notice that all my chart and table no more working . Because all field name have changes. Now i learn one more thing , need to make my data model okay before i go ahead to create table and chart.

Paul

[paulyeo11]

Hi Miguel

I cannot comment the other table SOURCE , because the qvw file i use are simple , in my actual app each table have 5 data file , diff ny source field for each country.

Paul

[miguelbraga]

Hey there,

Sorry for the delay, but your result is correct. Using that data model you will get the best performance and a clean solution You've achieve what you were looking for

Regards,

MB

[effinty2112]

Hi Paul,

Try:

Keys:

Load

ARKey,

SOURCE

Resident  AR_TABLE;

Load

ARKey,

SOURCE

Resident  ARSummary;

Load

ARKey,

SOURCE

Resident  Q_DOD_2016;

Link:

Load

Distinct

AutoNumber(ARKey & '|' & SOURCE,'LinkID') as LinkID,

SOURCE

Resident Keys;

Drop Table Keys;

Left Join(AR_TABLE) LOAD * Resident Link;

Left Join(ARSummary) LOAD * Resident Link;

Left Join(Q_DOD_2016) LOAD * Resident Link;

Drop Fields ARKey, SOURCE From AR_TABLE, ARSummary, Q_DOD_2016;

Gives this DM:

[paulyeo11]

‌HI Andrews

MAy I know you read my QVW Using Binary load and you add those script to create a link table it is ?

THank you very much for your sharing .

I Will test it when I got my PC

PAUL

[effinty2112]

Hi Paul,

               Hope it works for you. I removed the field ARKey from the data model, if you need it to remain then add the bold line shown below. Then ARKey will then appear in the link table and be selectable.

Kind regards

Andrew

Link:

Load

Distinct

AutoNumber(ARKey & '|' & SOURCE,'LinkID') as LinkID,

ARKey,

SOURCE

Resident Keys;