flag?

[Anonymous]

i have like

t1:

load

sales

amount

from sales.xlsx

now i am talikng resident for this

load

sales

'last_sales' as endsales

amount

resident t1;

here created a flag called   'endsales'  i understood

my question what is the data in inside the field of  'endsales'  i guess  data would be  'last_sales'

if not pls correct me ?

if yes what is the use of this flag here?

[#2 · Accepted solution]

Hi,

Here like this u vl get the data

Sales Endsales

100    last_sales

200    last_sales

130    last_sales

290    last_sales
300    last_sales

[its_anandrjs]

Hi,

You get last_sales string in all rows in the t1 table

sales, endsales , amount

7841,  last_sales, 45812

...

...

Regards

Anand

[Anonymous]

Your table will be loaded like this :

Sales Endsales Amount

100    last_sales  10

200    last_sales  50

130    last_sales  30

290    last_sales  10

300    last_sales  40

This flag is not useful until you are loading other tables as well like

If you load other table where you need to have flag 'Start_Sales' to identify the start sales amount.

Now in your expression you can use these flags to identify which amount belongs to END_SALES and which belongs to START_SALES .

Hope this help.