Create flag in script

[stephenedberkg]

i have two tables are table1 and table 2 that tables have same field so its auto concatenation .

but the two table have different sales are payable and receivable.

i want to take payable and receivable separately using flag.

How to create flag?

[Anonymous]

In the table1 load statement add :

     '1'     as     [Table1Flag] ,

     '0'     as     [Table2Flag] .

and for table2 :

     '0'     as     [Table1Flag] ,

     '1'     as     [Table2Flag] .