can any one explain me the why we will use flags in concatenation

[honeyasha]

can any one explain me the why we will use flags in concatenation with example.

[ahmar811]

Suppose we have Sales Actual value table and another one is Sales Budget with same field, in that case we have to concatenate these two table but after that how we know which field value is actual and which is budget value that time we have create flag so you can easyly understand using flag.

[qlikviewwizard]

Concatenate appends the rows of one table to another. Concatenate never merges any rows. The number of rows in a concatenated table is always the sum of the rows from the two input tables. Here's what our sample data will look like after Concatenate.

For example we have data like this.

Sales:

ID	DATE	Sales
1	7/6/2018	1
2	7/5/2018	2
3	7/2/2018	3
4	7/2/2018	4
5	7/1/2018	5
6	6/30/2018	6
7	6/30/2018	7
8	6/28/2018	8

Revenue:

ID	DATE	Revenue
4	7/2/2018	4
5	7/1/2018	5
6	6/30/2018	6
7	6/30/2018	7
8	6/28/2018	8
9	6/27/2018	9
10	6/26/2018	10
11	6/26/2018	11
12	6/24/2018	12
13	6/25/2018	13
14	6/22/2018	14
15	6/22/2018	15
16	6/20/2018	16
17	6/21/2018	17
18	6/18/2018	18
19	6/20/2018	19

Hope you got it.

[Anonymous]

Hi,

Suppose if we have combined two dates in a single column,

and if we are performing some transformation on that date then if we want to check the result

Then in this condition based on flag only we can verify that result.

If flag is not set then it is difficult to verify the output generated from operations performed.

Regards

Ritesh