I want to create Flags in Qv

[ajsjoshua]

I hav two tables,which hav common fields  and is autoconcatenated  , now i want the sales separately for each tables.

how to create flag for it.

[sunny_talwar]

May be like this:

LOAD Table1Fields,

          1 as TableFlag

FROM Source1

LOAD Table2Fields,

          2 as TableFlag

FROM Source2

[stephenedberkg]

Dear sunindia

i have faced this problem

1 as TableFlag

where i have to write this script and how to get the values in set analysis separately

[sunny_talwar]

So lets say you have two tables:

Table1:

LOAD FieldNames

FROM YourSource1;

Table2:

LOAD FieldNames //Assuming they are the same field names for autoconcatenate to work

FROM YourSource2;

Add Flags like this:

Table1:

LOAD FieldNames,

          1 as TableFlag

FROM YourSource1;

Table2:

LOAD FieldNames //Assuming they are the same field names for autoconcatenate to work

        2 as TableFlag

FROM YourSource2;

Once you reload your script, you can pull Table 1 like this:

{<TableFlag = {1}>}

For Table 2 replace 1 with 2 -> {<TableFlag = {2}>}

Does this answer your question Stephen?